Entry

How to convert MS-Access database to MySQL ?. Please give in detail.

Jan 20th, 2001 05:28
Chris Hayes, Naveen Ghanathe,

You can do it manually, in code, or download a special Access module 
for this purpose (easiest). 
Manually
Manually you can create similar tables in a database of MySQL, export 
data from Access to a .cvs file and use that as input files (see mysql 
documentation at 9.5.3).
CODING
There is also a MySQL command called LOAD_DATA_INFILE which claims to 
be fast.
ACCESS export module 'exportSQL'
With it you can export all tables in a MS-Access database file, 
including their make-up, to 2 text files: one containing SQL 
instructions to delete the new tables to be created, and the other with 
SQL instructions to create and insert data into the new tables. The 
table structure and data will resemble as much as possible the current 
Access database.
 www.cynergi.net/prod/exportsql/
 This code is provided free for anyones use and is therefore without 
guarantee or support.
 Plenty of detailed explanation included in the download.