C
Chappy
Hi,
I have recently started using a database and are looking to automate some
cumbersome processes. Staff have been entering a date field via a form but
due to the volume this is very time consuming.
I noticed that the relevant table had no primary key and had to create an
autonumber field to assist in importing this data. However when I try to
import the data from an Excel spreadsheet I receive an error message:
XXX was unable to append all the data to the table.
The contents of fields in 0 records were deleted and 3 records were lost due
to key violations.
The excel spreadsheet only contains 2 columns, one for the the primary key,
the other with a date. The date field is the one I wish to have the
information inserted into.
Any ideas?
Both are Office 2000 applications.
Cheers,
Chaps
I have recently started using a database and are looking to automate some
cumbersome processes. Staff have been entering a date field via a form but
due to the volume this is very time consuming.
I noticed that the relevant table had no primary key and had to create an
autonumber field to assist in importing this data. However when I try to
import the data from an Excel spreadsheet I receive an error message:
XXX was unable to append all the data to the table.
The contents of fields in 0 records were deleted and 3 records were lost due
to key violations.
The excel spreadsheet only contains 2 columns, one for the the primary key,
the other with a date. The date field is the one I wish to have the
information inserted into.
Any ideas?
Both are Office 2000 applications.
Cheers,
Chaps