SQL Injection Forum | Hacking & Exploit Tutorial - SQLiWiki
Move MS Access objects to MySQL Database - Printable Version

+- SQL Injection Forum | Hacking & Exploit Tutorial - SQLiWiki (http://forum.sqliwiki.com)
+-- Forum: SQL Injection Tutorial (http://forum.sqliwiki.com/forumdisplay.php?fid=3)
+--- Forum: MS Access Tutorial (http://forum.sqliwiki.com/forumdisplay.php?fid=14)
+--- Thread: Move MS Access objects to MySQL Database (/showthread.php?tid=5325)



Move MS Access objects to MySQL Database - sandycullen - 05-15-2019

A Database is composed of lots of files in which an application works. A single database has tables, records, indexes, and these tables have other entities as well together they form an entire database. So when planning to export a file from one database to other users must consider that other files also get transferred. For Example, when exporting a database table the user must also export its contents too. There are two options to migrate tables from MS Access method manual and automatic.

Transfer MS Access Tables to MySQL Free

For this, you need to make the connection with MS Access and MySQL using ODBC connector, check the steps given below
  • Open the MS Access application in your system
  • The database created will be listed in the tool, 
  • Right-click on the database table, select Export and then ODBC
  • Now type the table name in which data to be exported in MySQL
  • Click Next and select the Machine Data Source
  • Select the source origin as MySQL to export data
  • Now click on Next and transfer process will start 
  • When the data gets fully exported you will get a success message
So, this is the free method by which you can export the MS Access database files to MySQL. If you face any difficulties then try the DRPU MS Access to MySQL converter*** The software exports the file from one location to another without any problem and all the data will get migrated. It also exports the encrypted database files to MySQL.


RE: Move MS Access objects to MySQL Database - MarthaClarke30 - 07-18-2019

Will going to try this method!