Good morning all;
This one is blowing my mind and I could use a little expertise. I'm retrieving data from an Excel sheet, using a simple SQL query using a textbox as input to my variable. It works great when I enter an integer to search for (such as 213 for example) but when I put in a mixture of numbers and letters (48A for example) I get the following error: Syntax error (missing operator) in query expression '[P&L]=48A'. Can anyone tell me the fix for this? I know it has something somewhere to do with integers. Please help. My code is as follows...
Private Sub MPLS3() Dim BrNr As String BrNr = TextBox1.Text Dim stSQL As String = "SELECT [MPLS Date] FROM [Master Data$] WHERE [P&L]=" & BrNr & ";" Dim stCon As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=c:\branchinfo\BranchData.xls;" _ & "Extended Properties=""Excel 8.0;HDR=YES"";" Dim cnt As New OleDbConnection(stCon) Dim cmd As New OleDbCommand(stSQL, cnt) Dim adp As New OleDbDataAdapter(cmd) Dim ds As New DataSet Try cnt.Open() adp.Fill(ds) Me.Label1.Text = ds.Tables(0).Rows(0).Item(0) Catch Ex As Exception MessageBox.Show(Ex.Message) Finally cnt.Close() cnt = Nothing adp.Dispose() ds.Dispose() End Try End Sub
Edited 6 Years Ago by __avd: Added [code] tags.