Acess Problem

[PeteEHP]

I have acess 2000 and im trying to import records from a text file.
import 5 records with the auto number function works fine. Then when
try to import 5 more records it gives me this error
Microsot acess was unable to append all data to the table. Why is thi
happening and is their a way around this? I need the autoo numbe
function to work to keep track of my records?
Thank

 

[Tom Wickerath]

It would be helpful to provide some sample records, so that we can see the data you are
attempting to import. A table structure (fieldnames and datatype) would also be helpful.
Do you have a unique index (Indexed: Yes-->No Duplicates) on any of the fields? If so,
you may be attempting to import a value into a field that would be a duplicate to what was
already imported.

_________________________________________


I have acess 2000 and im trying to import records from a text file. i
import 5 records with the auto number function works fine. Then when i
try to import 5 more records it gives me this error
Microsot acess was unable to append all data to the table. Why is this
happening and is their a way around this? I need the autoo number
function to work to keep track of my records?
Thanks