10-27-2002, 04:08 AM
Is it possible to convert a MS Access database to MySQL format? Any help on how to achieve this will be greatly appreciated!
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.
10-30-2002, 05:08 AM
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'
10-30-2002, 12:56 PM
SQL from the command line is:
LOAD DATA LOCAL INFILE "myFile.txt" INTO TABLE myTable
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 :)
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.