Reading CSV or Excel files in java and mapping values to database columns
- From: "delcas2004@xxxxxxxxx" <delcas2004@xxxxxxxxx>
- Date: Wed, 20 Jun 2007 07:42:19 -0700
Dear colleagues,
I am looking for a free and simple mechanism for reading data from
files (could be CSV or XLS ) and inserting values that are read into a
database. I know that I could import a csv/xls file directly from a
database, but this is different. There is a Document Management
System in the mix. The use case is like this:
1) User creates csv/xls file with certain information ( i.e:
"male,usa,hispanic,married")
2) Java program reads file and maps string values to attribute
properties in the DMS
I've seen the Apache POI and a few other (Oster utils, etc) but I
haven't found something simple and flexible enough to allow me to
incorporate business logic as well as basic file i/o and string
manipulation.
If you have any information, tips or advice, I would greatly
appreciate it.
Kind regards,
Fer
.
- Follow-Ups:
- Re: Reading CSV or Excel files in java and mapping values to database columns
- From: dtaylor4
- Re: Reading CSV or Excel files in java and mapping values to database columns
- From: Dr ART
- Re: Reading CSV or Excel files in java and mapping values to database columns
- From: Roedy Green
- Re: Reading CSV or Excel files in java and mapping values to database columns
- From: TechBookReport
- Re: Reading CSV or Excel files in java and mapping values to database columns
- From: antonioatt
- Re: Reading CSV or Excel files in java and mapping values to database columns
- Prev by Date: Re: How to compare two large text files?
- Next by Date: Re: Cannot override protected fields
- Previous by thread: ejb 3.0: how using EntityClass from servlet?
- Next by thread: Re: Reading CSV or Excel files in java and mapping values to database columns
- Index(es):