import access table to excel spreadsheet
 

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,

import access table to excel spreadsheet
 

Hi Souris

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Souris" wrote in message ...
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,

import access table to excel spreadsheet
 

hi
you can do this from access or excel. several ways.
in access. select the table you want then on the menu bar select..
fileexport...
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...
Dataimport external datanew 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" wrote:

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,

import access table to excel spreadsheet
 

Thanks for the message.

"FSt1" wrote:

hi
you can do this from access or excel. several ways.
in access. select the table you want then on the menu bar select..
fileexport...
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...
Dataimport external datanew 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" wrote:

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,