Corect use of SQL

[AlexanderBB]

Hi,

I want to query some data in my worksheet using SQL. This may not be a good idea as I recall some problem with memory leaks or similar, but regardless I can't get it working and would like to

I'm using ADODB and I have a working connection (to the current workbook) and can get results using "Select * From...". But I don't want "*" instead I want to specify a column (or columns)

A few things found online didn't work here e.g. "Select [Sheetname$.Col1]... or 'select [F1], [F2] etc.
Please, what is the correct working syntax after SELECT ?

Perhaps part of the problem is the extended header? I'm using ='Excel 8.0;HDR=NO'. There were conflicting answers found for HDR, some said use NO even if there are headers. And to use "IMEX=1" but that just seemed to make the connection take longer.

Any advice most welcome, thanks !

 

[RoryA]

Can the memory leaks be plugged or otherwise handled?

They can't be plugged - it's a bug. They can be handled by using closed workbooks.

 

[AlexanderBB]

I wondered that too, and if careful coding would minimise or prevent the problem. Maybe someone knows ?

 

[AlexanderBB]

Thanks Rory, I wrote msg 12 before seeing your answer. So I guess not possible to use the current workbook. Pity.