This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes CSV to JDBC reader Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "CSV to JDBC reader " Watch "CSV to JDBC reader " New topic
Author

CSV to JDBC reader

Peter Rooke
Ranch Hand

Joined: Oct 21, 2004
Posts: 801

I'm looking at using a tool to parse CSV files, as if they were database tables. Have found two tools:

i) CSVJDBC
ii) xlSQL

My question is, and in terms of stability and extensibility which would be the preferred tool?


Regards Pete
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703
    
    5

Two questions for you...

Can you use a database? Why not write your own csv parser?

CSV files are just text files with a fancier name. While I'm sure those two packages you listed may have many special features and abilities for general database storage, something simpler and more custom may prove more applicable in your situation. The performance really depends on what you are going to do with it, and for something as simple as a CSV file, I'd probably want to write my own.


My Blog: Down Home Country Coding with Scott Selikoff
Peter Rooke
Ranch Hand

Joined: Oct 21, 2004
Posts: 801

Why not write your own
- Yes could do, but if there is a proven tool out there, would like to have a look at it. If I write something, I'm not convinced that it will be tested as fully as a tool developed as open source. Also want to get into the interesting parts of this project, and not spending time grinding code for a solution that has been done before.

Years back, had to write an Informix 4GL XML parser (well sort of :roll: ) for an old Informix database - did'nt enjoy this.

Mind you by the time I find any documentation for xlSQL - I could have written my own utility.
[ May 05, 2006: Message edited by: Peter Rooke ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: CSV to JDBC reader
 
Similar Threads
Generate CSV from Resultset
Converting .xls to csv
CSV file help
CSV Export
What's your favorite open source library/project?