ExcelBanter - How to accsees excel file from ODBC if file has no tablename?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to accsees excel file from ODBC if file has no tablename? (https://www.excelbanter.com/excel-programming/279827-how-accsees-excel-file-odbc-if-file-has-no-tablename.html)

Eugene[_4_]

How to accsees excel file from ODBC if file has no tablename?

keepITcool

How to accsees excel file from ODBC if file has no tablename?

In the query wizard's "Choose Columns" page
there's an option button....

Check to display system objects,
that'll enable you'll see sheetnames.

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool

"Eugene" wrote:

All times are GMT +1. The time now is 09:01 AM.