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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Creating a Chart on form from selected data in query. 0
Clean this select case code up a bit. 2
Page numbering with Merged Document and IF statements 1
Insert columns and values programmatically with IF statement 9
export excel data to access table using ADO 0
Finding the right style field in VBA 0
Pasting a cell into bookmarked table from excel vba 1

Top