ExcelBanter - Retrieving data from Access via SQL/ODBC

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

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

- - Retrieving data from Access via SQL/ODBC (https://www.excelbanter.com/excel-programming/287161-retrieving-data-access-via-sql-odbc.html)

Oliver[_2_]

Retrieving data from Access via SQL/ODBC

Hi all,

I have a lot of information stored in an Access database
which I would like to use in a calculation in Excel.

How can I run a SQL-Query against my Access Database in
VBA using ODBC?

Thanks a lot for your help!

oliver

All times are GMT +1. The time now is 10:40 AM.