Re: Importing data into the database using JDBC

Dave,

There's a short description of this in our marketplace at
https://www.zapatec.com/website/marketplace/showOneProject.jsp?oid=145072

We're a little bit in hurry with this, so we're probably going to start
soon, but would be interested in working with other people once we got
some functionality in place. I'm open to the idea of contributing
at least some of the code we'll write.

Error handling for this stuff is going to be a pain. There are a bunch
of error issues that we need to think of. I guess we can look and see
what other tools do.

Can you think of any Postgres specific functionality that would be
need to go into this, or do you think it can be a generic SQL/JDBC
solution?

Dror

On Sun, Nov 03, 2002 at 11:14:19PM -0500, Dave Cramer wrote:
> Dror,
>
> no, I'm not aware of any; but am interested.
>
> Do you have some specs for what you want to do?
>
> Dave
> On Fri, 2002-11-01 at 13:40, Dror Matalon wrote:
> > Hi folks,
> >
> > Anyone knows about any Java based tools to import data into the
> > database from CSV, Excel, and other formats?
> >
> > I know about the following resources for reading CSV and Excel:
> > http://jakarta.apache.org/poi/
> > http://ostermiller.org/utils/CSVLexer.html
> > http://sourceforge.net/projects/csvjdbc
> > http:// www.andykhan.com/jexcelapi/index.html
> >
> > Before writing the tool, I'm wondering if someone knows of higher level
> > tool to grab the data and import it into the database.
> >
> > --
> > Dror Matalon
> > Zapatec Inc
> > 1700 MLK Way
> > Berkeley, CA 94709
> > http://www.zapatec.com
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
> >
>
>
>

--
Dror Matalon
Zapatec Inc
1700 MLK Way
Berkeley, CA 94709
http://www.zapatec.com