-
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules