ExcelBanter - Excel and Access

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

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

- - Excel and Access (https://www.excelbanter.com/excel-programming/315781-excel-access.html)

Luis

Excel and Access

Hello.
Is it possible to use Access tables in Excel? The idea is to have an Excel
VBA macro that uses info stored on a Access Db table.

Jan Karel Pieterse

Excel and Access

Hi Luis,

Is it possible to use Access tables in Excel? The idea is to have an Excel
VBA macro that uses info stored on a Access Db table.

Sure. Check out Data, get external data, new database query.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

All times are GMT +1. The time now is 05:38 PM.