Dump data to multiple sheets in a CSV file

K

kutti

New Member
Hi All,

Usually i dump the data from the database into a comma delimited file. But if there are huge data (say > 65536) , I have to dump it in another CSV file. Is there any possibility to load the remaining data in the same file in a different sheet ???


Thanks In Advance,
Kutti.
 
Hi,

I don't think this is possible since a csv file is nothing but a flat file that only contains data and delimiters. If you need to create separate sheets you can dump the data into an xml file, with the appropriate tags of course, and save that as an xls, which a modern version of Excel will read no problem. Just create a couple of worksheets in Excel with a bit of data in them and choose to save it as an xml type file. You can then open the file with a text editor to see what it all looks like.

Paul
 
You must log in or register to reply here.
Back
Top