I have a 300k line 4GB CSV file that will not open in neither excel 2003 or 2010. I double click or file open it and excel will just open up a blank DB. Any advise? Won't open in notepad either. I am thinking I can open it in a better text editor and copy and paste it in quarters but there must be an easier way and this will cause problems when I save it and reopen it. Hope someone can help.
-
-
How much RAM you got? -
split the file into multiple parts112.020.756Comment
-
-
Excel has a limit of about 65k lines (2^16). Look it up. I found it out a few weeks ago. annoying but true.ICQ: 370 037 008Comment
-
Import it into a relational DB, make your changes then export back to CSV (if you must).I like pie.Comment
-
I have 8GB ram, I5.
Excel 2010 can open a million rows apparently.
How do I split the file into multiple parts?Comment
-
Ultraedit or notepad++agentGFY *at* gmail.comComment
-
An easy to use splitter
It's a zipped exe but the source files are easy to scan.
downloads/csv-splitter-1.1.zipComment
-
thx will try thoseComment
-
I like pie.Comment
-
are you using the 32 bit excel ?
i think there is a 2 gig file limit on the 32 bit.Need WebHosting ? Email me for some great deals [email protected]Comment
-
edit plus, csv splitter, notepad++ = fail
trying ultraedit, currently loading.
think i am using 32bit yes.Comment
-
Send it to me let me try. 24 gig ram and 64bit system.
Comment
-
Use Microsoft Access to open the database.Support American Heroes | How Bad is My Batch? | Vaccine Deaths & Adverse Reactions | Free Speech Coalition | <WARNING> ePayService / Guerra Capital, INC / MTACC payments | Flirt4Free Fucks their Affiliates | Don't do business with piece of shit Andy Alvarez from Webmaster Central / VR3000, who said:
"If it was up to me, they would have shot all 30,000 of those country loving shitheads"Comment
-
I know you have full excel but maybe you could try a lightweight version - excel viewer or smth..find it on google..Comment
-
Why in the world would you ever want to open a 4GB CSV in Excel?
I'd recommend importing it into a relational DB if you want to actually be able to DO anything with it, LOLICQ: 258-202-811 | Email: eric{at}bestxxxporn.comComment
-
If you want I can write a quick script for a few bucks to split the 4GB file into 10 smaller files... icq: 33375924Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000
Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager
Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip ManagerComment
-
try ultraedit. That's what I use when handling big files.Comment
-
notepad++ opened it but froze for a few minutes everytime I tried to copy a portion of it. and I can only copy 2 or 3% of it without getting a too big for clipboard message, not going to copy it into 50 pcs. So theres no other program other than csv splitter that will split this into 4 pcs? CSV splitter split it into 1 467 kb file.Comment
-
Comment