How to get access 2003 data table particular data in excel.

  • Thread starter Thread starter Anupam Soral
  • Start date Start date
A

Anupam Soral

How thru macro we can get access 2003 data table particular data in excel
worksheet.
 
Use the External data tools

Data->Import External Data-> New Database Query

Then choose your source as MS Access and select and set options for your MDB

If you turn on macro recorder before you carry out above you will get the
code.
 
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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Best way to get data from Access 2003 to Excel 2003 6
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to split an excel workbook in code and data 2
VBA - retrieve data on last create named range from previous inserted named range 0
Excel VBA - Problem with Closing Print Preview 0
Macro to add data once a Pivot Table has been refreshed 1

Back
Top