How do I import a huge CSV file into Access 2007?
Posted 31 July 2013 - 12:46 PM
Posted 03 June 2014 - 07:51 PM
one alternative to splitting the csv horizontally is to split it vertically.
That is import it into another database mysql or sqllite and then export the first ten columns, and the the next 20 column with a key field of course , to get under the limit and then join them back inside access. Just an idea
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users