exporting actinic database to mysql

[davie_ne1]

I am trying to export the actinic database into a mysql database but i jkeep getting this error when I try to import the Order Tracking table

[2006-07-20 14:12:34] [Msg] Import start
[2006-07-20 14:12:34] [Msg] Import type - MS Access database
[2006-07-20 14:12:34] [Msg] Import from - G:\ActinicCatalog.mdb
[2006-07-20 14:12:34] [Err] Cannot create table [OrderTracking]: 1280 - Incorrect index name 'Primary'
[2006-07-20 14:12:34] [Err] create table `OrderTracking` (`nID` int AUTO_INCREMENT,`nOrderSequenceNumber` int,`nSSPProviderID` int,`sTrackingNumber` varchar(100),`sSSPOpaqueData` varchar(255),`nActualCost` double,`dWeight` double,`sOpaqueData` longtext,`sProductDetails` longtext,`sDateTimeExported` longtext,`bContentsUndefined` tinyint,key `OrderSequenceNumber` (`nOrderSequenceNumber`),key `Primary` (`nOrderSequenceNumber`)) type=innodb
[2006-07-20 14:12:34] [Msg] Processed:0, Added:0, Updated:0, Deleted:0, Errors:0
[2006-07-20 14:12:34] [Msg] Finished - Unsuccessfully

all the other tables import fine.

any ideas

[Bruce]

David,

For the previous query I attached a document, please take a look at point 7. Have you defined a 'Primary Key'?

Note 7: If the external file is an SQL database, you will also need to define a 'Primary Key' field for your data, or else Actinic will not be able to create the external link properly. You can use your 'Product Reference' column as your primary key if no other field is available.

Kind regards,