Convert Large CS file to many sheetss in one XLS

Hello,

that's very interesting case. Has anybody found the solution??? How to split large CSV into smaller files?

I have database which has 5 milions rows... Can I put it into Excel??

I would suggest that even if it is possible it can not be the best way to use the data. This is what databases were designed for, why microsoft has access, in a spreadsheet it would be very slow to do anything and this would be after much fiddling to get the data into excel in the first place. Each save would take an inorrdinate amount of time. If the file did need splitting the simplest way would be in any database picking the records from the csv file to export to create the seperate csv file.

Regards

Dav

I understand.. You are right. Maybe you have some tutorial how to export large csv to access or sql?

In access you just open a new database, save it to some name, the get external data and import, choose text as the type of data and then go through the wizard, it is comma delimitted and you may or may not have the variable names in the first line of the file. Try it, if it does not work you have not lost any data!

Any joy?

Regards

Dav