import access table to excel spreadsheet

[Souris]

I would like to import MS Access data in to my spreadsheet.
Do you have any example to do this tasks?
Your information is great appreciated,

 

[Ron de Bruin]

Hi Souris

See this page
http://www.rondebruin.nl/accessexcel.htm

 

[FSt1]

hi
you can do this from access or excel. several ways.
in access. select the table you want then on the menu bar select..
file>export...
at the top of the export dialog box, brouse to the place you xl file is.
at the bottome. select the xl file you want the data in. click export.

in excel, on the menu bar select...
Data>import external data>new database query.
set your db type to access database then follow the wizard.
this will create a refreshable query that you can update.

there are other ways to do this but the above may be considered the simplest.
Regards
FSt1

 

[Souris]

Thanks for the message.

hi
you can do this from access or excel. several ways.
in access. select the table you want then on the menu bar select..
file>export...
at the top of the export dialog box, brouse to the place you xl file is.
at the bottome. select the xl file you want the data in. click export.

in excel, on the menu bar select...
Data>import external data>new database query.
set your db type to access database then follow the wizard.
this will create a refreshable query that you can update.

there are other ways to do this but the above may be considered the simplest.
Regards
FSt1