Access/SQL ETL (Extract Transfer Load)
Posted on 2014-02-05
I have an Access database that has tables that are linked to SQL.
On a daily basis the data from one of the tables (circa 40000 rows) has to be
be downloaded into Access, edited and uploaded again.
I was told that the process is referred to as ETL (Extract Transfer Load)
where the linked table is converted into an Access table, the SQL index column is dropped.
Then data is edited and added in Access and finally re-uploaded.
What is the best way to do this? I assume that a mix of VBA and queries will be necessary