Public Sub importDeals() 'Die alten Stagedaten entfernen CurrentDb.execute "delete from STG_DEALS" 'Das CSV einlesen DoCmd.TransferText acImportDelim, "IN_STG_DEALS", "STG_DEALS", "C:\am_access_apps\deals.csv", True 'Normalisieren des Users CurrentDb.execute "VW_RUN_INSERT_USER" CurrentDb.execute "VW_RUN_ADD_USER_ID_TO_STG" 'Daten in die TBL_DEALS überführen CurrentDb.execute "VW_RUN_APPEND_TO_DEALS" End Sub