Update table based on external data

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I have a file that gets pushed from a mainframe to my local server every day.
I then have a database that I need to update the Master file from the data
push.
The data push is a .dbf file how in code would I do this.

Thanks
Michelle
 
Michelle,

If the file is always named the same I would link the file into my MS Access
DB, then run an update query to append records to the desired table. If your
table is keyed correctly you should have no problems with dups etc. Hope
this helps you out.
 
Back
Top