How to import multiple columns from a csv file into multiple table in MS Access 2016
I have a CSV file which imports into Excel as more than 255 columns (actually 666 columns).
As Access has a 255 column limit I need to parse the CSV file and import these into 10 different tables (254 columns and one link column).
How can this be achieved in VBA? I need vba as the CSV changes over the year and has a different name depending on when it is generated.
Most columns do/have nothing in them but it is the only output created.