Comparing an Imported table to an existing one

  • Thread starter Thread starter CDM
  • Start date Start date
C

CDM

I import a spreadsheet to Access daily and it has every customer in our
database. I also have tblClients that needs to be updated with these new
customers. I have written a procedure that loops through every record in
tblImports and checks to see if the record exists in tblClients, if not, it
adds a record. Is there a faster way to do that in VB?
 
Since I do this daily, I need to put a button on a form that someone could
just click for those days when I'm not around. I know this might be
involved..is there a site that has sample code.
 
Back
Top