Export Data to text/excel file

[bluethunder]

Good day,

I have a program where the report has a range before you can preview it. The user wants the record be export to .txt and excel file. Is there any idea how to construct it via code?

[Sudaraka]

It's a simple matter of building the for mat you want in a string and writing it to a file.

For excel you can use CSV (http://en.wikipedia.org/wiki/Comma-s...es#Basic_rules) format, and the text file can be simillar but columns separated by tab or use fixed length (space padded).

Only thing to be concerned is the amount of of data you need to write to the file, if it too big you might run out of memory. In that case you will have to stream or buffer the output.

[bluethunder]

Is there any sample code so that I could follow it.

[Sudaraka]

Try these:

http://vb6stuff.blogspot.com/2009/08/export-sql-data-to-csv.html

http://www.a1vbcode.com/snippet-2532.asp

[bluethunder]

Thank you for the reply. Both link that you gave to me is for csv file. Is there for txt file?

[Sudaraka]

You can use the same for the text files also.
Only things is that file name should end with .txt extension and format can be any thing you like.