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