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,

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,

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,

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,