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

Spike,
Try:
"SELECT .... WHERE fund=" & Chr(34) & fundname & Chr(34)

NickHK

"Spike" <(E-Mail Removed)> wrote in message
news:B0BB0CBF-9A6A-4EE0-AE62-(E-Mail Removed)...
> 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

Works like a dream thank you so much
--
with kind regards

Spike


"NickHK" wrote:

> Spike,
> Try:
> "SELECT .... WHERE fund=" & Chr(34) & fundname & Chr(34)
>
> NickHK
>
> "Spike" <(E-Mail Removed)> wrote in message
> news:B0BB0CBF-9A6A-4EE0-AE62-(E-Mail Removed)...
> > 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
>
>
>