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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only