Access to MySQL

[Danny]

Can an access database be converted to a MySql database?

THnaks in advance

[Bas Cost Budde]

Re: Access to MySQL

Danny wrote:
[color=blue]
> Can an access database be converted to a MySql database?
>
> THnaks in advance
>[/color]
The data portion for sure! I made a small tool in Access to export all
tables and references, and optionally all data, as SQL DDL statements.
Interested? See my site, Code Modules:SQLTool


--
Bas Cost Budde

http://www.heuveltop.org/BasCB

but the domain is nl

[Steve Jorgensen]

Re: Access to MySQL

On Thu, 12 Feb 2004 21:25:08 +0100, Bas Cost Budde <bas@heuveltop. org> wrote:
[color=blue]
>Danny wrote:
>[color=green]
>> Can an access database be converted to a MySql database?
>>
>> THnaks in advance
>>[/color]
>The data portion for sure! I made a small tool in Access to export all
>tables and references, and optionally all data, as SQL DDL statements.
>Interested? See my site, Code Modules:SQLTool[/color]

I just had to write something very similar for PostgreSQL. The only
difference is that I use an insert query to copy the data, so it's make the
tables, populate the tables, create the indexes, then create the relations.
It works great.

[Tony Toews]

Re: Access to MySQL

Bas Cost Budde <bas@heuveltop. org> wrote:
[color=blue]
>The data portion for sure! I made a small tool in Access to export all
>tables and references, and optionally all data, as SQL DDL statements.
>Interested? See my site, Code Modules:SQLTool[/color]

Very nice. Thanks. Link added to my site.

http://www.granite.ab.ca/access/accesslinks.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm

[rkc]

Re: Access to MySQL


"Danny" <dannywork5@hot mail.com> wrote in message
news:uaRWb.1190 7$I67.4669834@n ews4.srv.hcvlny .cv.net...[color=blue]
> Can an access database be converted to a MySql database?[/color]

I believe you can export Jet tables as file type ODBC to a
MySQL DSN.

[Steve Jorgensen]

Re: Access to MySQL

On Fri, 13 Feb 2004 02:55:08 GMT, "rkc" <rkc@yabba.dabb a.do.rochester. rr.bomb>
wrote:
[color=blue]
>
>"Danny" <dannywork5@hot mail.com> wrote in message
>news:uaRWb.119 07$I67.4669834@ news4.srv.hcvln y.cv.net...[color=green]
>> Can an access database be converted to a MySql database?[/color]
>
>I believe you can export Jet tables as file type ODBC to a
>MySQL DSN.
>[/color]

Not really, you can export tables, but Autonumbers, primary keys,
relationships, and some other things don't export along with them.

[Bas Cost Budde]

Re: Access to MySQL

Steve Jorgensen wrote:
[color=blue]
> you can export tables, but Autonumbers, primary keys,
> relationships, and some other things don't export along with them.[/color]

I do not have a provision for Autonumber either. I could try and create
a CREATE TRIGGER statement for that...

--
Bas Cost Budde

http://www.heuveltop.org/BasCB

but the domain is nl