Access to MySQL?

[kanji2150]

Hey Guys, this is the first time I've posted over in the database section. I am working on a project for the academic computing department of my college and I need to convert an excel spreadsheet into a database. I read up on it a little and I saw a few things about converting access databases to mysql. So I converted the excel document to access.

Anyways... I basically just wanted some input on what everyone thinks the best/easiest way to convert either the excel or access db to a mysql database. Thanks in advance!

-Jason

[jdt]

If your database is not too big you can probably try to create INSERT statements from you Access DB to be used on any other DBMS.


select 'insert into yourtable values (', attr1, attr2, ');' from yourtable


You will use COALESCE where NULL's can be expected.

[knotts]

or you can save your excel file to .csv --> .txt

then load it to your sql

load data infile 'something.txt' into table test fields terminated by ',';

hope it helps

_______________________
less than $1/month web hosting
http://www.onemillionhost.com