moving data from access to mysql 1

[Jooky68]

I am writing a program in java that is to move the data from MS Access to MySQL. There already is a table structure of the Access database in MySQL, all I need to do is move the data from Access to MySQL. I was hoping that someone may have done this before and could give me some pointers as to which would be the best way to implement this. Any suggestions would be greatly appreciated, the database is not huge so that is not really a factor.

 

[Bastien]

quickest way is to convert the access data to a csv file and use the load infile command to import the entire file into a table

Bastien

Cat, the other other white meat

 

[Jooky68]

I know this is not a java forum. But would anyone know if there is an easy way to export the access data into csv files? Instead of looping through each table and going through all the checks for strings etc...? Possibly a shell command or something through odbc? Any help would be greatly appreciated

 

[TonyGroves]

If your tables are small enough (32k records is a typical limit), you could import them into spreadsheets and save as CSV.

-----
ALTER world DROP war, ADD peace;