>-----Original Message----- >From: mos [mailto:mo...@fastmail.fm] >Sent: Monday, December 29, 2008 11:52 PM >To: mysql@lists.mysql.com >Subject: How to convert Acess 2007 ACCDB file to MySQL? > >Someone has given me an Access 2007 file *.ACCDB and I don't have Access >2007. Is there a (preferably free) way to convert it to CSV or MySQL? >
Since my previous post, it occurred to me that the cheap and flexible way to convert your Access database into CVS it to use OpenOffice! You can open the .accdb file with OpenOffice Base, then drag the tables one by one over to Calc spreadsheets, and save them as CVS files. Opening an Access database in Base is a little confusing, you have to "connect" to it rather than open it directly, but you don't need any ODBC or JDBC at all. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
