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.

--

Regards,
Nigel




"Anupam Soral" wrote in message
...
How thru macro we can get access 2003 data table particular data in excel
worksheet.
--
Anupam