Importing Excel files

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

I have an Excel file that I would like to inmport into an
existing table. I practiced using a copy of the table
and it worked fine. However, when I tried importing the
Excel file to the original table I receive an error
message stating that the records were lost due to key
violations.

Does anyone have any ideas about what I am doing wrong?

Tracy
 
You probably have a Unique Index or Primary Key Field in your Table and the
values to be imported from Excel duplicate the existing values in the Table.
 
There is a Primary Key Field that contains Social
Security Numbers in the table but none of them are
duplicated. I can't figure why the process works on the
copy of the table but not the original.
 
If it works on the copy, it should work on the real one.

Just make sure you don't get mixed up and try importing to the same copy
again.

Otherwise, I got no ideas.
 
Thanks.
-----Original Message-----
If it works on the copy, it should work on the real one.

Just make sure you don't get mixed up and try importing to the same copy
again.

Otherwise, I got no ideas.

--
HTH
Van T. Dinh
MVP (Access)







.
Click to expand...
 
If I may throw in my 1.5 cents here (I'm not knowledgeable
enough for a full two cents):

Depending on how you made a copy of the spreadsheet this
can happen. The problem is that Transfer Spreadsheet
sometimes does weird things if it comes across a formula.
The best thing you can do is make a copy of your sheet
containing only data, no formulas.
 
Thank you, I'll try that.
-----Original Message-----
If I may throw in my 1.5 cents here (I'm not knowledgeable
enough for a full two cents):

Depending on how you made a copy of the spreadsheet this
can happen. The problem is that Transfer Spreadsheet
sometimes does weird things if it comes across a formula.
The best thing you can do is make a copy of your sheet
containing only data, no formulas.


.
Click to expand...
 
Back
Top