>From: mos [mailto:mos99@stripped]
>Sent: Monday, December 29, 2008 11:52 PM
>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.
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341