There are jdbc drivers for csv files, that could simplify one end of the task.
http://tinyurl.com/bwrpn You may want to look to your db vendor, too - I know M$ SQL has tools for importing this sort of data...and i suspect others do, too. Larry On 9/22/05, Warren Bell <[EMAIL PROTECTED]> wrote: > My company has several vendors who send us invoices in the form of comma > delimited flat text files via FTP. My question is, is there a way using > Ibatis to pul in the data from the text file and insert it into a table. I > can get the data in manually and use Ibatis to insert into the table, but it > would sure be nice if I could use Ibatis and map the fields in the flat file > to my objects the same way they are maped from tables or say do a query > like: > > INSERT INTO table SELECT field1, field2 ... FROM flat_file > > These vendors have no other way to get us our invoices except paper. > > Thanks, > > Warren Bell > > >
