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.