PHPMyAdmin: Access->MySQL?

[Anon]

I already place my question here but it was removed I do not know why.

Is there a way to transfer Access table into MySQL table
using PHPmyAdmin? What other shells exists to work with MySql?

[Anon]

The best way I know of to do this is to use Access to create .csv or .txt file, which can be handled (I think) by PHPMyAdmin. I doubt if there is any direct way of importing data from an .mdb file (unless you're running on a Windows platform - then you can get something like DBTools to do just that).

-Keegan

[Anon]

I found solution myself. If it will help somebody, send me your "thank you" to [e-mail] 😉))))

So in Access you need to choose the table to export. Then go to file->export table-> as text file->(DO NOT SAVE FORMATTED ! )->save all -> delimeted -> tab as delimeter -> text qualifiyer "none" -> save file at mysql\data\database_name\file_name.txt

In phpMyAdmin in the SQL query window type:

LOAD DATA LOCAL INFILE "C:\mysql\data\database_name\file_name.txt" into table table_name;

Press button GO.

phpMyAdmin will say it cannot show you page. It's OK. Go back, refresh your browser and look at your table - it got records!!!

There is a bug though 🙁((( All dates are entered as 0's.

Maybe somebody else has solution for dates?

[Anon]

Thank you Keegan!

[Anon]

hi,

there's a script to export the hole database under http://www.cynergi.net/exportsql/
it places a txt-fle in your temp-directory, which could be imported in mysql.

greetings from germany

stefan