I run a records business and have all my stock, and suppliers' stock in an Access 2016 database
I have externally linked tables to Excel spreadsheets that i get from the suppliers (tblSupplierData), these are updated daily.
I need to have a main central table (tblAllData) where each individual record has a unique ID (tblSupplierData.UniqueID).
This table is exported to CSV, and used on various marketplaces to enable delete uploads, so that if an item is no longer available, it is removed from my account on the marketplace. All i have to do is upload the file - the marketplace takes care of the rest, but requires that i have a unique ID for each item, and that unique ID cannot change.
So, what i need to do is delete records from tblAllData that no longer exist in tblSupplierData
I'm sure this should be simple as it seems fairly normal thing to do
The workaround i have got in mind, if all else fails, is to run an additional query that takes the relevant data from both tblSupplierData and tblAllData and create an entirely new table, but with there being currently 200k records, that seems a little inefficient, doubley so in that I've got another 200k records to go.
Any help appreciated
Regards
David
I have externally linked tables to Excel spreadsheets that i get from the suppliers (tblSupplierData), these are updated daily.
I need to have a main central table (tblAllData) where each individual record has a unique ID (tblSupplierData.UniqueID).
This table is exported to CSV, and used on various marketplaces to enable delete uploads, so that if an item is no longer available, it is removed from my account on the marketplace. All i have to do is upload the file - the marketplace takes care of the rest, but requires that i have a unique ID for each item, and that unique ID cannot change.
So, what i need to do is delete records from tblAllData that no longer exist in tblSupplierData
I'm sure this should be simple as it seems fairly normal thing to do
The workaround i have got in mind, if all else fails, is to run an additional query that takes the relevant data from both tblSupplierData and tblAllData and create an entirely new table, but with there being currently 200k records, that seems a little inefficient, doubley so in that I've got another 200k records to go.
Any help appreciated
Regards
David