MySQL

Jessie Fitzgerld
Jessie Fitzgerld used Ask the Experts™
on
I'm trying to import tables from my Access database, I was actually successful at importing one table, but since haven't been able to import anything. I'm using the same data source and I can see the tables but they won't import to the MySQL database I selected.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017

Commented:
Make sure that the ACE tables do not contain any data types such as mult-value, hyperlink, etc.  None of the new data types introduced in A2007 can be upsized.
Ryan ChongSoftware Team Lead

Commented:
what tool are you using to import Access tables to MySQL ?

Author

Commented:
I am trying to import my Access database tables  to MYSQL with ODBC the first attempt was successful, after that I was able to export them to the MYSQL database, but not my targeted database.
Ryan ChongSoftware Team Lead

Commented:
I am trying to import my Access database tables  to MYSQL with ODBC

can you tell us what ODBC tool are you referring to? I'm still not very clear how those tables were imported into MySQL.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial