Data Import from MS-Access into MySQL
I have ubuntu 12.04 installed. I have installed MySQL workbench.
I have data in MS-Access. I am ubable to import MS-Access data into MySQL.
I created a database using Workbench. When I try to list databases using the command show databases; in the terminal, it does not show the database created in Workbench.
Please solve the following issues:
1- How to import MS-Access data into MySQL?
2- In general, how to import MS-Excel or Open Document data into MySQL?
3- How to access databases created by Workbench using the terminal?
4- Where does Workbench save databases?
Can you help with this problem?
Provide an answer of your own, or ask Iqbal for more information if necessary.