I’m currently attempting to transfer my data from an Excel file or CSV to an MS Access DB
I have currently set up:
-Connecting to MS Access file
-Read my CSV File
-Output my CSV to a Data Table variable
The parts I’m struggling and would like some advise with are:
-“For each row” and assigning my rows and how it works
-Using the correct “Insert” query
Using "Insert into ‘Name of my table’ doesn’t seem to get picked up properly.
Hope this explains my issue clearly.