View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spike Spike is offline
external usenet poster
 
Posts: 140
Default ADO SQL syntax query, using a variable

I need to extract data from a csv file for a specific fund, i have the syntax
to do this by coding the fund name into the SQL string, but what is the SQL
statement syntax to use if you wish to use a variable to hold the fund name.
So instead of ....WHERE fund = 'XYZ'. i have tried WHERE fund= fundname.
Fundname being the variable holding the fund name. This produces an error.

I will be very grateful for any help in this
--
with kind regards

Spike