ADO to XLSX file from Excel 2003

M

Mike Clemens

Does any know if its possible to use ADO to get data from an XLSX or XLSM file
when the macro is run from Excel 2003? In other words will the
MICROSOFT.ACE.OLEDB.12.0 provide work from Excel 2003?

Thanks

Mike Clemens
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Importing .xlsm, .xlsx with OLEDB 5
ADO connection to Excel 2007 *.xlsx files? 8
ADO connection to a protected workbook? 3
forwards/backward compatibility Excel 2003-2007 8
reading excel 2007 returns 255 columns! 3
export excel data to access table using ADO 0
Export specific fields from access to Excel 0

Top