Access to MySQL

[Danny]

Can an access database be converted to a MySql database?

THnaks in advance

[Bas Cost Budde]

Danny wrote:

Can an access database be converted to a MySql database?

THnaks in advance

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]

On Thu, 12 Feb 2004 21:25:08 +0100, Bas Cost Budde <ba*@heuveltop.org> wrote:

Danny wrote:

Can an access database be converted to a MySql database?

THnaks in advance

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

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]

Bas Cost Budde <ba*@heuveltop.org> wrote:

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

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]

"Danny" <da********@hotmail.com> wrote in message
news:ua*********************@news4.srv.hcvlny.cv.n et...

Can an access database be converted to a MySql database?

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

[Steve Jorgensen]

On Fri, 13 Feb 2004 02:55:08 GMT, "rkc" <rk*@yabba.dabba.do.rochester.rr.bomb>
wrote:

"Danny" <da********@hotmail.com> wrote in message
news:ua*********************@news4.srv.hcvlny.cv. net...

Can an access database be converted to a MySql database?

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

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

[Bas Cost Budde]

Steve Jorgensen wrote:

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

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