SQL Statement with Excel
Hi everybody
I have been asked to "Create a contact Database" with obligation to use only Excel, not Access.
I manage 2 to 3000 records and I need to add selection function.
I read in Wrox book "VBA for Excel 2002" that I still could use ADO to query an Excel file. This works with some coding obligations ie
a simple SQL statement, once the ADO connection created, looks as follows:
StrSQL="Select * from [Data$a1:h1415]"
This is also written in this book that the 1st line is by default recognized as column names, this being very useful to create SQL statements with a WHERE clause.
I fail writing this WHERE clause and would urgently need some help since I have to provide my solution somewhere end of next week.
I would really appreciate your hints since I am slightly lost.
Great thanks in advance
|
