troubleshooting Question

How to handle a 3 gigabyte CSV file

Avatar of Jason C. Levine
Jason C. LevineFlag for United States of America asked on
DatabasesMicrosoft AccessMySQL Server
10 Comments3 Solutions670 ViewsLast Modified:
Hi folks,

We've been given a 3.5 gig CSV file that I need to get into a database somehow.  We have access to MySQL and Access 2003 and 2007 but I'm stumped on how to convert a file of this size to a MySQL query and Access seems to not want to open it at all.  

What tools do I need to do this?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros