paul.hartland at fsmail.net
paul.hartland at fsmail.net
Tue Apr 6 03:42:01 CDT 2004
Darren, try taking a look at the first ten characters of the DBase IV table fields you are trying to import (i.e. you may have something like StudentsID1 and StudentsID2 if you look at the first ten characters you will only have StudentsID) for some reason when trying to Export/Import DBase IV tables it only reads the first ten characters. Make sure the first ten characters in your fields are different and then you should be ok. Paul Message date : Apr 06 2004, 06:01 AM >From : "Darren DICK" To : "AccessD List" Copy to : Subject : [AccessD] A2K: Transfer Database hello all can anyone tell me why the acLink version of transfer database below works but the import version fails? Along with the error message "Cannot define Field more than once" I have tried every combination I can think of in relation to the dbf file name location etc. No joy and the help is useless 'This one works fine DoCmd.TransferDatabase acLink, "dBase IV", "C:\", acTable, "C:\SIDS.dbf", "tblStudents", False 'This one fails DoCmd.TransferDatabase acImport, "dBase IV", "C:\", acTable, "C:\SIDS.dbf", "tblStudents", False many thanks Drren -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com Join the UK's number one for the internet www.freeserve.com/time