TransferSpreadsheet Excel to Access, Update instead of Append

Badswell

Registered User.
Local time
Today, 07:16
Joined
Feb 13, 2004
Messages
34
I have some large code that is based around "DoCmd.TransferSpreadsheet" but it appends by default. Any ideas on how to get this to update exist data instead of bombing out due to primary key restrictions?

I was thinking of uploading to a junk table, then automating some queries to update the main table & clear the junk table. However, the issue arrises of multiple people being in the table at once and I'm concerned it would cause read-only problems and data not being transfered correctly.
 
Well your stuck.... sorry to say any Transfer command is Append ONLY...

You will have to go your junk table....
 

Users who are viewing this thread

Back
Top Bottom