Home » Open Source » MySQL » Any MS Access to MySQL database conversion tool
Any MS Access to MySQL database conversion tool [message #596744] Thu, 26 September 2013 02:12 Go to next message
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?
Re: Any MS Access to MySQL database conversion tool [message #596746 is a reply to message #596744] Thu, 26 September 2013 02:13 Go to previous messageGo to next message
Littlefoot
Messages: 19465
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Only one record? I'd (manually) type an INSERT statement.
Re: Any MS Access to MySQL database conversion tool [message #596880 is a reply to message #596744] Fri, 27 September 2013 00:52 Go to previous messageGo to next message
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 Go to previous message
ThomasG
Messages: 3099
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
Previous Topic: Locking in Mysql procedure
Next Topic: Slow Query
Goto Forum:
  


Current Time: Wed Aug 20 02:22:35 CDT 2014

Total time taken to generate the page: 0.05255 seconds