Getting Data From MS Access Database

  • Thread starter Thread starter M P
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

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

Bring Data From MS Acess in a Combobox 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Good morning 5
MS Query keeps getting Out of Memory messages 1
Linking Access Query to Excel make DB Read Only 1
Running MS Query on an Excel Spreadsheet 3
Access #Error & Excel Pivot 0
Inform Password in Excel VBA Code 1

Back
Top