2007-01-25 02:36:08 · 3 answers · asked by APNim 2 in Computers & Internet ➔ Programming & Design
Almost every database will let you export data as CSV (Comma Separated Value) format or as Microsoft Excel format, so as long as the tables are basically the same in both databases, it shouldn't be too hard.
email me if you have trouble exporting the data from Access. I'm not really a MySQL expert, so you may have to figure that part out yourself.
2007-01-25 02:42:04 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Not sure about MySQL, but Microsoft SQL server can be linked to Access.
2007-01-25 14:54:43 · answer #2 · answered by Richard H 7 · 0⤊ 0⤋
Try out this handy article: http://www.kitebird.com/articles/access-migrate.html
Which is appropriately named "Migrating from Microsoft Access to MySQL". (Google is your friend!)
2007-01-25 10:43:49 · answer #3 · answered by idiot9990 1 · 0⤊ 0⤋