DownLoading Data from SQL Server

[j_Southern]

I am using the following code to download data from SQL server.

Please Login or Register  to view this content.

When I run this The line rst.Open StrSql, ConnStr is highlighted and the SQL server error message "Invalid column name StartDate" is shown.
StartDate and LastDate are parameter variables used in the last part of StrSQL. I have replaced these with several other names but all give the same error.
This is the first time I have queried an SQL server and the first time I have used an ADODB connection so I am stuck.
Help please

***NB The last line of StrSQL has a> and a< replaced by "2" and "3". This is because > and < are causing a Forum FireWall to activate. (See recent post from me and advice given)
John

[Kyle123]

You need to put the variables into the string, right now you're just passing a string with "StartDate" and "EndDate" in.

Please Login or Register  to view this content.

P.S Always format your dates so that they're unambiguous when using databases

[j_Southern]

Thank you for your help. Your code worked fine. All I had to do was make sure the formatting was done outside the SQL string.
John