Importing Excel File into Northwind Template

[jdopson616]

Hello

My name Is Jeff. I am using MS Access 2010. I am building a purchasing inventory DB using the template in access. I am trying to import excel pricing files in to the products table. However it doesn't work, I have tried using the append query function still doesn't work. I can import the file as a new table but i cant link the 2 together so my "Products" button brings up all the part numbers. I dont want to have to copy and paste 5424 lines. Thoughts?

 

[Ranman256]

Append queries DO work, I use them all the time.
Link the excel file as a table,
Build an append query to import the data.

Join the 2 tables on the same field. (Same type too)

 

[jdopson616]

i tried that and i get this error. I upload a picture of the error, Says 5416 records set to null for type conversion failure