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.
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.