Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting to CSV
Message
From
24/11/2001 13:40:59
Jeroen Naus
Harte-Hanks Europe
Hasselt, Belgium
 
 
To
20/11/2001 16:44:40
General information
Forum:
Java
Category:
Databases
Miscellaneous
Thread ID:
00584215
Message ID:
00585408
Views:
14
You could use the output stream object and the file object to generate the csv file your self. Just loop over all the records and fields in your query and write them out to your file with a "," in between them....

>Hi,
>
>I'm a Java rookie looking for help on taking a MS SQL Server query result set and dumping it to a CSV file. I have to take invoice and customer data from our in house system and get it into CSV files in order to be imported into ACCPAC accounting software.
>
>Any help would be MOST appreciated.
>
>Thanks,
>
>Glenn Stockfisch
Previous
Reply
Map
View

Click here to load this message in the networking platform