Trying to update one table with another table using update query, Help please

[slavisa]

Im having trouble with updating my 1 table with the information from another!

I have a table with 6 fields.

Code(pk), Name, Title, Address, State, city, zip

the table is called Info.

Now i have a excel file which i imported it in the access db as a table called newinfo

the new info has only 5 of the fields.

Name, Title, Address, State, city and zip

Im trying to update the "Info" table with the information from the "NewInfo" table using an update query but im having no luck at all.

any help or advice on how my sql statement should look like or anything would help alot.

[FishVal]

Hi, slavisa.

What type is [code] table field?

[slavisa]

the field is a text field

[FishVal]

the field is a text field

The field is PK. You need to give it value unique for each record. Update query will fail unless a unique value for [code] field is being generated dynamically, for example via VBA function.
What is supposed to be in [code] field?

[slavisa]

thanks for that little info, in my excel sheet i had to place the Code and have it as pk, this way it knows which row to replace. I've tested it today and it worked.

thanks