aspose file tools*
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
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
 
 
subject: connecting to a CSV or other delimitted file