Sep 15 2005, 11:55 AM
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,
Sep 15 2005, 12:02 PM
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.
Sep 16 2005, 08:42 AM
Thank you for the reply. I tried to create the update query with joined tables, but no success? Any suggestions?
Sep 16 2005, 10:36 AM
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.
Sep 16 2005, 12:38 PM
Eureka!!! I did check the data type, made the change and it worked great!! Thanks again!!
Sep 16 2005, 01:12 PM
You're welcome. I'm glad it worked.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here