Getting Data From MS Access Database

M

M P

Is this possible? I have MS Access DB on the file server and wanting to
query directly from ms excel. Hoping for your fast response.

Me
 
D

Dong Gaofeng

absolutely,you can make use of ADO to get data from Access DB via VBA code

OR you can click "data" ->"import externl data"->"database query"
so you can choose the data source and set up some query conditions.
 
Top