Comparing an Imported table to an existing one

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?
 
P

Pete D.

Why not just use an append query that compares fields and adds what isn't
found.
 
C

CDM

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table cleanup 3
Help with SQL 3
Copy non-duplicates from new file to existing file 1
Import a dbf database into existing access table? 2
problem importing information from excel into access 0
Update Query Error 5
Check table for like values 4
How do I update existing records within a database? 3

Top