Converting MS Access DB to MySQL format

kestrel7

10-27-2002, 04:08 AM

Hi
Is it possible to convert a MS Access database to MySQL format? Any help on how to achieve this will be greatly appreciated!

HormonX

10-29-2002, 10:26 PM

From what i can remember you can export your database from ms access as a CSV file , and the import it into MySQL.

HormonX

kestrel7

10-30-2002, 05:08 AM

Hi,

Thanks for your reply HarmonX

I'm sure I can figure out how to export from Access, but do you have any idea about how I go about importing files to mysql?

Would something like this work?

LOAD DATA INFILE 'blah/blah/blah/file.csv'

bcarl314

10-30-2002, 12:56 PM

SQL from the command line is:

LOAD DATA LOCAL INFILE "myFile.txt" INTO TABLE myTable

kestrel7

10-31-2002, 05:35 AM

Thanks for all the help. Tried it and it worked like a charm :thumbsup: BTW, what does the LOCAL stand for? Is it as in the file is local and does this mean you can load a file from a remote location using something like 'REMOTE' instead of LOCAL? Just curious :)

HormonX

11-05-2002, 02:43 AM

No .. you can't user REMOTE :) if you want to read more about i sugest you check this link out. It explains why LOAD DATA LOCAL is used.
http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html

HormonX :thumbsup: