how should the whole database be dumped?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dubing@gmail.com - 04 Apr 2006 21:28 GMT

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

Reply to this Message

Rick Brandt - 04 Apr 2006 23:54 GMT

> Hello,
>
[quoted text clipped - 4 lines]
>
> 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.

Signature

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

Reply to this Message

com - 05 Apr 2006 19:46 GMT

>Hello,
>
[quoted text clipped - 6 lines]
>
>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.

Reply to this Message