Data Import from MS-Access into MySQL

Asked by Iqbal on 2013-02-02

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?


Question information

English Edit question
Gearman MySQL UDF Edit question
No assignee Edit question
Last query:
Last reply:
Jason (zzs) said : #1

1, Check Access to MySQL,
2, Export to comma delimited text file.
3, Did you launch it by /usr/bin/mysql-workbench

Iqbal (naqvi-iqbal2001) said : #2

I launch it from Dash.

Jason (zzs) said : #3

what do you mean terminal?

Jason (zzs) said : #4

If you want to execute sql statement, you do not need to run workbench from the terminal

Can you help with this problem?

Provide an answer of your own, or ask Iqbal for more information if necessary.

To post a message you must log in.