By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,787 Members | 2,251 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,787 IT Pros & Developers. It's quick & easy.

import Ms access data into MySql

P: 14
hello everyone how can i import Ms Access data into MySql thank you
Feb 12 '08 #1
Share this Question
Share on Google+
10 Replies


mwasif
Expert 100+
P: 801
Checkout MySQL migration toolkit.
Feb 12 '08 #2

ronverdonk
Expert 2.5K+
P: 4,258
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.

Ronald
Feb 13 '08 #3

P: 4
hello everyone how can i import Ms Access data into MySql thank you
First export the tables from MS-Access into a text file and then use infile command to import that text file into MySQL.
Here is an example of infile command:

LOAD DATA INFILE name_of_exported_file.txt
INTO TABLE table_name
FIELDS TERMINATED BY ,
LINES TERMINATED BY \r\n;
Feb 18 '08 #4

P: 14
thank for all yr help guy really appreciate
Feb 18 '08 #5

ronverdonk
Expert 2.5K+
P: 4,258
thank for all yr help guy really appreciate
That why we are here (one of our goals in life).
Do you want to tell us what solution you g=have chosen?

Ronald
Feb 18 '08 #6

docdiesel
Expert 100+
P: 297
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:

Expand|Select|Wrap|Line Numbers
  1. INSERT INTO
  2.   mysql_connected_table1
  3. SELECT
  4.   *
  5. FROM
  6.   access_old_table ;
Regards,

Bernd
Feb 18 '08 #7

ronverdonk
Expert 2.5K+
P: 4,258
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.

Ronald
Feb 18 '08 #8

P: 1
I have the distinctive feeling that the MySQL migration kit for Access is not free of charge (but I could be wrong).
...
Ronald
Actually, you are :P. Mysql Migration tools are released under the GPL and under commercial license by mysql for any OS.

More info:
http://dev.mysql.com/downloads/gui-tools/5.0.html

Hope it helps,

Pedro.
Mar 22 '08 #9

ronverdonk
Expert 2.5K+
P: 4,258
Actually, you are :P. Mysql Migration tools are released under the GPL and under commercial license by mysql for any OS.

More info:
http://dev.mysql.com/downloads/gui-tools/5.0.html

Hope it helps,

Pedro.
Pedro, you are absolutely right about this. So it was entirely my mistake. Soory foir that.
Ronald
Mar 22 '08 #10

P: 1
You can use MySQL import wizard in dbForge Studio for MySQL. This MySQL GUI tool has MS Access format as well.
May 30 '17 #11

Post your reply

Sign in to post your reply or Sign up for a free account.