Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

How do I import a huge CSV file into Access 2007?

Started by KenPC , Apr 14 2010 10:56 AM

Please log in to reply

#16
starjax

Posted 31 July 2013 - 12:46 PM

Global Moderator

Global Moderator
6,678 posts

with a spreadsheet of that size you probably won't be happy, even if you get it into access. While I'm not an excerpt with sql, it will probably suit your needs much better. If you can't afford it, try looking at mysql.

#17
ozmike

Posted 03 June 2014 - 07:51 PM

New Member

Member
1 posts

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