Export MySQL to MDB file

[lee taylor-vaughan]

Hi,
I recently uploaded all my MDB tables to MySQL. i created an ODBC to the MySQL datatables.

now I need to put them back in the MDB file. I tried the import feature in access, however, all the AutoNumber fields are now only number. I tried to changed them back (in access) to autonumber and it does not permit me to change them to autonumber.

how can i import all my MySQL tables back in to acess MDB file and keep the field type as AutoNumber field setting?

I'm very new to SQL. I dont understand scripts/sql etc... so please, if you can, provide a basic way to accomplish this.

thanks a ton..
lee