I have a classic ASP application, which needs to query an excel file. My current query looks like this and it works fine.SELECT colhdr1,colhdr2,colhdr3 FROM [Sheet1$].
Now the problem is, for some reason if the colhdrX spelled wrong, this query will fail. So without using a colhdrX, how can I rewrite this using a range. Say colhdr1 will always be A, colhdr2 will always be E and so on...I tried to rewrite this as below and it is not working. Any ideas how can I achieve this?SELECT [A:A] AS colhdr1,[E:E] AS colhdr2,[D:D] AS colhdr3 FROM [Sheet1$].
ThanksKarunakaran
Querying Excel With Range
Posted - 2008-05-20 : 12:25:23