Update Access table through excel

Vergy39

Registered User.
Local time
Today, 00:31
Joined
Nov 6, 2009
Messages
109
I hope this is the correct forum for this. I have an access database that is used to store records of requests for for items. Example, ID, WhoRequested, CustomerName, Date, address, phone, WhatRequested, amt. I take this data and export it to an excel spreadsheet and send to another area for processing. I then get the sheet back with the orderdate, ordernumber, and shippingnumber. I need to update the original table with this new information. it is not bad when there is only a few, but Ihave had 100 or so lately, and updating each record manually is time consuming. After looking on google and on this forum, I think I need to use VBA for this, but not real knowledgeable of VBA. Any assistance is greatly appreciated.

Thanks
David V
 

Users who are viewing this thread

Back
Top Bottom