By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 981 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

Access to MySQL

P: n/a
Can an access database be converted to a MySql database?

THnaks in advance

Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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.
Nov 12 '05 #3

P: n/a
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
Nov 12 '05 #4

P: n/a
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.
Nov 12 '05 #5

P: n/a
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.
Nov 12 '05 #6

P: n/a
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

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.