Hi
I have 3 different Access Files , each contain around 1,988,826 KB data and in that each file has 3 different tables
my end goal is to combine all 3 files based on field names.
I tried just to combine 3 different files it is taking me more than 40 mins to load the data.
Is there a way where i can insert data and run the entire workflow in less than 5 mins
is it possible to connect In-db tool to Access file ??
Note : i can't connect to SQL database due to internal restrictions