UPSERT Query Performance

[samuel.erde]

I have a large table (almost 4 million records, 12 fields) in Access
that is cleared and re-populated over a WAN connection on a daily
basis. It is time consuming. Is there any chance that an UPSERT
query might help this to go faster, or would it likely take about the
same amount of time?

Thanks,
Sam

 

[vanderghast]

Can also check this one, access free of charge:

http://www.databasejournal.com/feat...1/UPSERT-Functionality-in-SQL-Server-2008.htm



Vanderghast, Access MVP

 

[samuel.erde]

Can also check this one, access free of charge:

http://www.databasejournal.com/features/mssql/article.php/3739131/UPS...

Vanderghast, Access MVP

Maybe this article would be helpful in answering question. Have to
register
to site (free) which I did not bother with.
http://www.sqlservercentral.com/articles/T-SQL/61773/

BTW, I am using Access for this process, not SQL Server (which I do
know would be ideal.)