error message importing excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I imported 34 months of data (34 files) that were exactly formatted the same
for a flat file database. This month I have to add a file. I thought that I
had formatted this file the same as the others but it is not imorting. I am
getting the following error message:

"The contents in 3304 record(s) were deleted, and 0 records were lost due to
key violations.
*If the data was deleted , the data you posted or imported doesn't match the
field data types or the field size property in the destination table.
*If the records were lost, either the records you pasted contain primary key
values that already exist in the destination table or they violate
referential integrity rules for a relationship defined between tables.
Do you wish to proceed anyway?" I clicked "NO" and the data was not imported.

I imported the first 34 tables and then changed the format in ACCESS
afterward. Now that I am adding the 35th table am I getting the error
message because my excel format does not match the new Access format? Will
Access not automatically update the data in the 35th file to the new format
and decimal places, etc?

Thanks for your help.
Chris
 
I figured it out. I had to replace all # symbols in date fields with a blank
space. I had just forgotten what I had done the month before.

Thanks anyway.
 
Back
Top