Importing Excel files

[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

 

[Van T. Dinh]

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.

 

[Guest]

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.

 

[Van T. Dinh]

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.

 

[Guest]

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)







.

 

[Ernie]

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.

 

[Tracy]

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.


.