This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes connecting to a CSV or other delimitted file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "connecting to a CSV or other delimitted file" Watch "connecting to a CSV or other delimitted file" New topic
Author

connecting to a CSV or other delimitted file

John Bushell
Greenhorn

Joined: Jun 12, 2002
Posts: 16
all,
can you connect via a JDBC driver of some sort, to a flat file that is pipe delimitted i.e. :
20000002197|||2||KING GEORGE V AVENUE||
20000002198|||4||KING GEORGE V AVENUE||
20000002199|||6||KING GEORGE V AVENUE||
many thanks
John
[ April 15, 2003: Message edited by: John Bushell ]

thanks a bunch for your help<br />John
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

usually your desktop will have a microsoft text driver in its ODBC driver list. If this doesn't satisfy your requirements, you can search google for many other JDBC text driver solutions.
Jamie
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: connecting to a CSV or other delimitted file
 
Similar Threads
Most portable format for data
1066 And All That
Oakland/Berkley
Import CDR File into Sql Database
WA #1.....word association