MS-Access, only works in Windows and MS-Office only or is it?
As I am no longer using Microsoft products, I do have one that is a little harder to switch. I have a Customer base database. It holds all of my customer information and invoices. And as my title suggest, to work with the database you have to Windows and MS-Office. But it is possible to get the data out of the database file and insert into another database. I am switching to MySQL 5, I have the MS-Access Database file, for this example called myDB.mdb. I am using my MacBook Pro, I download program call RazorSQL, I went to their site downloaded the program and follow the direction on setting up the program. For this example I will not explain on how to set it up, they will have update directions on their site. (http://www.razorsql.com/articles/ms_access_mac_os_x.html).
Now when you have it setup and running you will see something like this: (I will go through this step by set)
From here you want to to to DB Tools -> Export Data
here make sure that you select the table you want to export
Here you want to select "SQL Statements" and "Generate SQL Insert Statements"
here you want to select "
This save box I added .sql to the end of the file, just so that I know that it is to be imported into MySql
