Apache Friends Support Forum

Hello everyone,

I am running Access 2007 and MySQL from an XAMPP install and using the MySQL Migration Toolkit and am attempting to import a Access2003 mdb file into MySQL. I have the toolkit set up correctly and am able to go through the whole process without errors, but when I viewed the database on MySQL I found that all of the tables and fields were correct, but no data entries had been ported over. I reviewed the log and found this error whenever a SQL statement like "Select *" was run:

[Microsoft][ODBC Microsoft Access Driver] Unknown

I downloaded the latest MDAC and have the ODBC drivers for Access. Is this my problem and they aren't compatible with older access database files?

Thank you for help in advance before I run out of hair to pull.

Is this thread of any help?

http://community.apachefriends.org/f/viewtopic.php?p=109609


===========================================
1. The new DeskTopXampp Launch Control for XAMPP / XAMPPlite
Posted by Ridgewood available from Ridgewood'sDTX web site

2. Build Rich AJAX Applications - Faster
TIBCO General Interface Pro Edition but FREE and Open Source
Fully working with NO donations required to get a user/password
===========================================

Izzy wrote:Is this thread of any help?

http://community.apachefriends.org/f/viewtopic.php?p=109609

Thanks for the reply, that thread seems to be geared for having problems with ODBC connecting to MySQL where I seem to be having problems with the Access ODBC driver and unsure if has something to do with having Access 2007.