hello everyone how can i import Ms Access data into MySql thank you
import Ms access data into MySql
Collapse
X
-
-
I have the distinctive feeling that the MySQL migration kit for Access is not free of charge (but I could be wrong).
Another solution would be to do it yourself.
Write a server application (like PHP) that reads the tables and data from the Access database and stores it into the MySQL database.
Using a (free) tool like Adodb makes it relatively easy to do.
Holler when you need more info.
RonaldComment
-
Originally posted by milas57hello everyone how can i import Ms Access data into MySql thank you
Here is an example of infile command:
LOAD DATA INFILE ‘name_of_export ed_file.txt’
INTO TABLE table_name
FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ‘\r\n’;Comment
-
Originally posted by milas57thank for all yr help guy really appreciate
Do you want to tell us what solution you g=have chosen?
RonaldComment
-
Hi,
how about copying the tables contents directly by INSERT INTO SELECT FROM..., without having to export/import them and so on?
Of course first you've got to create the tables in mySQL with phpMyAdmin or another mySQL tool. Then all you need is a Window$-PC with Access and the mySQL ODBC driver. Open the Access database and create a new table - but make it a linked table, using the OBDC entry of your mySQL database as source. Select the appropriate mySQL table. Then copy the data from within Acce$$ by using SQL:
Code:INSERT INTO mysql_connected_table1 SELECT * FROM access_old_table ;
BerndComment
-
Like MySQL, the MS Access db must have meta data about the tables you want to copy. So read the Access table's metadata, construct a MySQL CREATE TABLE command with that information and issue it.
Then copy (INSERT as in the previous post) and you're done.
RonaldComment
-
Originally posted by ronverdonkI have the distinctive feeling that the MySQL migration kit for Access is not free of charge (but I could be wrong).
...
Ronald
More info:
Hope it helps,
Pedro.Comment
-
Originally posted by pedroblActually, you are :P. Mysql Migration tools are released under the GPL and under commercial license by mysql for any OS.
More info:
Hope it helps,
Pedro.
RonaldComment
-
You can use MySQL import wizard in dbForge Studio for MySQL. This MySQL GUI tool has MS Access format as well.Comment
Comment