Originally Posted by
ArviLaanemets
1. You have e.g. an Excel table on shared resource. New info is entered/copied/read into this table. In case every new row must be added into Access table, every row in this Excel data table must have some unique (time) template/counter saved at creation time, which will be stored into Access table too. In case some Access table must be updated with data from Excel table, then the Excel table must have columns allowing to identify the data to be updated;
2. You link the Excel table into your Access database. NB! The users will not have any access to linked table - not directly, and not through any forms!;
3. You create a VBA procedure in Acccess database, which reads data from linked table, evaluates the validity of data, and inserts valid data into Access table(s) or updates Access table(s) with valid data. NB! This is the only use for linked table!;
4. You create some control or form event which runs the procedure. Or you write a script run by scheduled task on some server/computer, which opens the Access database and runs the procedure.