how should the whole database be dumped?

[dubing]

Hello,

In Access 2000, I know how to export each table in a database. But how
should I dump the whole database which has many tables? The dump
should be saved in a file which can be then used to import into MySQL?
Can it be done in Access or I have to use some extra tool?

Thanks in advance for any ideas,

Bing

[Rick Brandt]

<du****@gmail.com> wrote in message
news:11**********************@e56g2000cwe.googlegr oups.com...

Hello,

In Access 2000, I know how to export each table in a database. But how
should I dump the whole database which has many tables? The dump
should be saved in a file which can be then used to import into MySQL?
Can it be done in Access or I have to use some extra tool?

Thanks in advance for any ideas,

I don't know of any tool that will give you a "dump" for an Access database like
you can in some server based databases. There might be third party tools that
would do it and you could write your own I suppose, but you would need to do
this a lot for it to be worth the effort.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[com]

On 4 Apr 2006 13:28:46 -0700, du****@gmail.com wrote:

Hello,

In Access 2000, I know how to export each table in a database. But how
should I dump the whole database which has many tables? The dump
should be saved in a file which can be then used to import into MySQL?
Can it be done in Access or I have to use some extra tool?

Thanks in advance for any ideas,

Bing

Copy the mdb file?
It would be simple to copy just the tables, but why bother.

To copy tables into an alien database I usually create an empty template, link to a copy of it
(which you can make each time by program) and using the existing links do the copying from the
Access end.