SQL Statements for excel sheets via ADO
Posted on 2003-11-04
I have a problem in accessing the excel sheets via ADO using SQL command. If I access the excel sheets using a single word field (e.g. PartNo), I can retrieve the data without problem but if I try to retrieve data using a two word field (e.g. First Name), I will have an exception. Does anyone have any idea how to solve this problem.
select * from pract$ where PartNo is 'A1234' // this can work
select * from pract$ where First Name is 'John' // this cannot work
A billion thanks