I need to upload my Excel spreadsheet into an existing Access table, compare the account #'s in the field and if the account #'s match, I need the dollar amount from the Excel spreadsheet to be placed into the matching dollar amount field in Access. The two fields from the spreadsheet have the same name as the two fields in Access. So basically this is what I'm looking for: If Excel account # 123 = Access account # 123, then place the dollar from Excel spreadsheet into the dollar amount field in Access. If no match is found, then leave that row blank and then search the next record. I have no idea where to begin other than linking or importing the spreadsheet into Access.

Thanks for any help,

missjjones

You should begin as you have already stated. Make a copy of the "Access" table of interest. Then an Update query developed that joins the two tables on the account # field. You would want to update the "Access" dollar amount to the "Excel" dollar amount.

Edited by: fkegley on Thu Sep 15 13:03:17 EDT 2005.

Thank you for the reply. I tried to create the update query with joined tables, but no success? Any suggestions?

Check the type and size of the "join" fields in each table. It is possible that Access has imported the Excel field into a different type than in the "Access" table of interest.

Eureka!!! I did check the data type, made the change and it worked great!! Thanks again!!

You're welcome. I'm glad it worked.