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.