Import Excel Access - Primary Key - Append table

[mduplantis]

Hi,



I am familiar with importing Access, but I am getting an error with the process of adding new employee phone numbers.

• My Access tables uses a the employee number as its primary key.
• I have a new field in my access table called employee phone number.
• I have an Excel worksheet that contains the employee number and employee phone number as columns
• All heading match and all data types are the same

My goal is to populate the new employee phone numbers for each employee number in my access table.

Is this possible using the import function of Acess? Or is there a different approach for appending a record?

Thank you.

[aytee111]

You aren't appending records, you are trying to update existing records.

What is the error that you are getting?

[mduplantis]

Hello,

Yes, updating existing records. It tells me the records were lost due to KEY VIOLATIONS.

[aytee111]

That error is usually connected to APPEND queries, make sure yours is an update query.

[mduplantis]

I was using the import menu from Excel in the Access menu bar. Is there a different way to update the table?

[aytee111]

You need to first import the file and then run an update query - two separate processes.

[mduplantis]

I will give that a shot. Thanks

[mduplantis]

That worked!! Thanks for the help. Greatly appreciated!