Extract nth-column of Excel when using database connection string


#1

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.

Cheers


#2

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

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