all,
it really long shot can't seem find any code spinets to get me started or if its even possible.
Right..... i have 3 tables
Main table "Main table holds the current data "
History table "history table holds old data from main table "
excel Import table "temp table that holds data import from excel"
already worked the code out to import the excel data to a table ("excelimport")
need to compare the maintbl and excelimport table if field (key1) matches then old records get added to history table and existing records in maintbl get updated from the data from excelimport and new records get added.
sorry not very good at explaining so i have made a spread sheet showing the before tables and after table once the excel import is done also attached test db. aswell
any help much appreciated
thanks in advance
Shane
View attachment testdb.xlsx
View attachment TestDB.accdb
it really long shot can't seem find any code spinets to get me started or if its even possible.
Right..... i have 3 tables
Main table "Main table holds the current data "
History table "history table holds old data from main table "
excel Import table "temp table that holds data import from excel"
already worked the code out to import the excel data to a table ("excelimport")
need to compare the maintbl and excelimport table if field (key1) matches then old records get added to history table and existing records in maintbl get updated from the data from excelimport and new records get added.
sorry not very good at explaining so i have made a spread sheet showing the before tables and after table once the excel import is done also attached test db. aswell
any help much appreciated
thanks in advance
Shane
View attachment testdb.xlsx
View attachment TestDB.accdb
Last edited: