Query To Get Excel Data Using Vb Script

Legacy Poster

• 2012年05月14日 15:52

Hi there. I'm facing problem using vb script with SQL query to get the info i want from Excel file.

My Excel file basically has 5 fields in Ship To Lists sheet,
Name Address 1 Address 2 Address 3 Address 4

I have did a dropdown list to get the Name field.That works ok. I also gave it a share name call Place.

What i want is a query that can return the address 1 field based on what the user has selected for the dropdown list.
This is what i did for the code but i kept getting expected end of statement error in the query.

[code]
Dim strQuery
strQuery = "SELECT [Address 1] FROM [Ship To Lists$] WHERE [Name] = '& Format.NamedSubstrings("Place").Value & '
[/code]

I think i have mislook something. Please help me look on this.
I didn't post my above code (connection) and below code (loop to search) here. But that's all work fine.
Any help would be greatly appreciated.
Thanks.

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • 2012年05月15日 02:06
  At least you need to quote string by "" (double quotations) - would it work?
  [code]
  "SELECT [Address 1] FROM [Ship To Lists$] WHERE [Name] = '" & Format.NamedSubstrings("Place").Value & "'"
  [/code]

  0

請登入寫評論。