OraFAQ Forum: MySQL » Any MS Access to MySQL database conversion tool

Home » Open Source » MySQL » Any MS Access to MySQL database conversion tool

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Any MS Access to MySQL database conversion tool [message #596744]

Thu, 26 September 2013 02:12

arnihta
Messages: 1
Registered: September 2013

Junior Member

I am looking solution to convert MS Access database record into MySQL database.
Anyone knows how it becomes possible?

Report message to a moderator

Re: Any MS Access to MySQL database conversion tool [message #596746 is a reply to message #596744]

Thu, 26 September 2013 02:13

Littlefoot
Messages: 21756
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Only one record? I'd (manually) type an INSERT statement.

Report message to a moderator

Re: Any MS Access to MySQL database conversion tool [message #596880 is a reply to message #596744]

Fri, 27 September 2013 00:52

arnim
Messages: 1
Registered: September 2013

Junior Member

You can found several tools for MS Access to MySQL database conversion.
You can try software from here:http://www.prodatadoctor.net/downloadsoftware/tools-to-convert-database/ms-access-to-mysql-conversion-program.html

[Updated on: Fri, 27 September 2013 00:52]

Report message to a moderator

Re: Any MS Access to MySQL database conversion tool [message #601279 is a reply to message #596880]

Tue, 19 November 2013 02:45

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Another option would be to install the MySQL ODBC driver, "link" the MySQL Tables into Access and then run insert queries from Access to MySQL

http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-examples-tools-with-access.html

Report message to a moderator

Previous Topic:	Locking in Mysql procedure
Next Topic:	Slow Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 30 03:03:58 CST 2023