asked on

Export fields from a ResultsSet to a new table similar to FoxPro

I want to take the colums, rows from my ResultSet and automatically create and export to a new table similar to the FoxPro command “Export to tablename type dbf or csv”

ASKER CERTIFIED SOLUTION

for_yan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

for_yan

If you want to go ore sophisticated - download OPEN CSV
and they have a special method which dumps ResultSet to CSV

http://opencsv.sourceforge.net/#sql-integration

java.sql.ResultSet myResultSet = ....
writer.writeAll(myResultSet, includeHeaders);

for_yan

This is the source of OpenCSV
http://opencsv.sourceforge.net/

http://sourceforge.net/projects/opencsv/

a useful package when it comes to writing the CSV files -espcially if your data have embedded commas, etc
when it beciomes not so straightforward

And aslo dumping the whole result set to csv in one line - useful thing

Vanavah Edwards

ASKER

Thanks I will try the program code above and get back to you. It looks like the solution. I have also posted for a visual calender for a datafield on the internet.

for_yan

vanavah,
Pleas, dont post in that old trail
https://www.experts-exchange.com/questions/27411392/Does-Swing-come-with-Calendar-and-time-field-components.html

which was initiated (and then closed ) more than a month ago by another person - I mentioned it for you to take solution from there not to use it for posting.

I posted several replies to your questions in your trail related to date checking:

https://www.experts-exchange.com/questions/27476343/Date-formatter-field-with-built-in-method-testing.html?cid=1131

Use your own questions to post stuff related to your questions