Hello,

I have database with csv format,when I opened it using MS excell there have problem error "File not loaded completely" (only open 65,536 records).

File size is 466MB with more than 2,000,000 records.

1.My question is how to view all record without have any error?
2.I want splitted the database into 10 parts,because I have maximum limit uploaded database on my phpmyadmin only 50MB,how to do that?

Any help will apreciated.Thanks

Ed

GSplit 2.0 - File Splitter - Homepage

Thanks chrishirst,want try it

Edit:
After try it,software working good but every pieces files can not format to csv files,i have confirm to creator its only help split to give more space to hard drive or FDD or USB disk,so this software not like what I want.By the way thank you very much.

If any suggest how to open (view) my csv files without lost any records (loaded completely) will apreciated.Have try many csv software but they are not work.

Make multiple CSV files

Originally Posted by saadatshah

Make multiple CSV files

Errmm Yes. That's why the OP is looking for something to do that




Found it! Knew I would locate it somewhere

Free HTML Tool - File Splitter
from
Handling Large Server Log Files -> High Rankings® Search Engine Optimization Forum

Originally Posted by saadatshah

Make multiple CSV files

Can let me know how,is out there any covert tool from csv to ms access,I searching but only found ms access to csv.

Is there ms access can view all data records?
Thanks.