Need help getting Access 2010 database into MySQL

[mosk]

I'm trying to get an Access 2010 database into MySQL so I can use it in Drupal. I downloaded Bullzip and used it to convert one Database without problems. On the second, database, however, I get the following error message when I try to import the newly made SQL file through PHPMyAdmin on my local host installation of WAMP:




MySQL said:
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key SQL query:
CREATE TABLE `Contacts` (
`ContactID` INTEGER NOT NULL AUTO_INCREMENT ,
`CompanyName` VARCHAR( 50 ) ,
`Address` VARCHAR( 255 ) ,
`Represents` VARCHAR( 50 ) ,
`StateOrProvince` VARCHAR( 20 ) ,
`City` VARCHAR( 50 ) ,
`PostalCode` VARCHAR( 20 ) ,
`WorkPhone` VARCHAR( 30 ) ,
`Notes` LONGTEXT
) ENGINE = MYISAM DEFAULT CHARSET = utf8;


Looking at the Access database, my file only has one auto column (ContactID set to AutoNumber) and it is set as the only key - so not sure where to go from here.

Thanks for any help.

[mosk]

Ok - solved this by unchecking an 'Auto Number Properties' option that must have been adding an extra auto property during the conversion.