MS Access database support - how should the whole database be dumped?

Author

how should the whole database be dumped?

dubing@gmail.com

2006-04-04, 8:30 pm

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

2006-04-04, 8:30 pm

<dubing@gmail.com> wrote in message
news:1144182526.787664.171790@e56g2000cwe.googlegroups.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

2006-04-05, 8:28 pm

On 4 Apr 2006 13:28:46 -0700, dubing@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.

Sponsored Links