update records in db from excel (not adding new)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wish to build a Access database that I will update daily with new records
from a Excel file. Once a week I would like update all records that match
with a unique reference code, with additional fields, again from a Excel
file. This DB will contain order details that agents have place with our
distributer, and forwarded to us (Excel file). Then our distributer sends us
a excel file with this information, plus date of delivery, costs etc.
 
Use TransferSpreadsheet to link the Excel spreadsheet as a table, then append
the data from the spreadsheet into your Access table. Unless there are some
processing issues with the data, you can create an append query to do this.
Because you are doing this on a daily basis, you can use either VBA code or a
macro to accomplish this task.
 
Back
Top