Append queries for Access Dummies

[Dee]

I designed my tables in the following format:
PartsTable
----------
PartNum
Material
AmtMaterial
MaterialInv#

Then based on recommendation that I not store duplicate
data I(probably mistakenly since I may not understand the
concept) created a lookup table for PartTable.Material
based on:

MaterialsTable
--------------
AutoNumber
MaterialName

Now I am trying to use an append query to populate my
PartTable. The append data comes from an imported Excel
spreadsheet. The append query will not work.

What in particular(if not the whole design) could be the
problem?

thanks for any assistance you can provide this Access dummy

 

[Guest]

What do you mean by "the append query will not work"? Do
you get an error, or are you not getting the results that
you desire?

Also, looking at your tables, I would have expected the
Materials table to have Material and Material name as
columns. Material would be the lookup field from
PartsTable to Material Table to retrieve material name.

 

[Dee]

I get a "Microsoft Access set 44 fields to NULL due to
type conversion failure, and it didn't add 0 records to
the table due to key violations and it.........."