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

A

Anupam Soral

How thru macro we can get access 2003 data table particular data in excel
worksheet.
 
N

Nigel

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.
 

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
How to split an excel workbook in code and data 2
Passing data to an event handler 3
VBA - retrieve data on last create named range from previous inserted named range 0
Macro to add data once a Pivot Table has been refreshed 1
Getting information from access table in excel 1

Top