Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

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


  • Please log in to reply

#16
starjax

starjax

    Global Moderator

  • Global Moderator
  • 6,591 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.
  • 0

Advertisements


#17
ozmike

ozmike

    New Member

  • Member
  • Pip
  • 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


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP