Extract nth-column of Excel when using database connection string

I’m using OLEDB to extract huge amount of data from Excel. I’m not using Excel App. Scope. Also, the data in Excel has no header.

I can extract the data from entire worksheet with query “select * from [Sheet1$]”.

May I know the syntax to use to extract all the data of Column A only of Sheet1? I supposed it’s something like “select * from [Sheet1$ > Column1]” or something along that line?

Sorry I can’t find this info. anywhere.

Thanks again for your help.


“SELECT A FROM [Sheet1$]”
“SELECT * FROM [Sheet1$A]”

Can’t test at the moment but they might both work?