Acess Problem

  • Thread starter Thread starter PeteEHP
  • Start date Start date
P

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup Acess 2
Unable to append all the data to the table when importing 6
Problems Importing Excel Data to Acess 1
Access 2007 Problem with Forms 1
acess sum 7
importing data from Microsoft Works 2
Database Import Duplicate Issue 0
access database on a network 1

Back
Top