access a column via a select statement

G

Guest

Hi,

I am trying to access a excel spreadsheet using the OleDB.

I have been able to open the worksheet up, but it would seem that I can only
perform 'select * from [sheet1$]'

I want to be able to select only a small number of columns from the sheet,
but when i try 'select A,B from [sheet1$]' it causes an error.

Is there a specific syntax to access Column A/B in a select statement ?

Thanks
 
Top