Re: Question on csv import using browser into MySQL database

2006-05-23 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tim Lucia said the following on 5/23/2006 10:51 AM: > I've used a CSV JDBC driver once before with success. It becomes an > exercise of reading from one JDBC connection and writing to the other. > > http://csvjdbc.sourceforge.net > > Tim Christopher,

RE: Question on csv import using browser into MySQL database

2006-05-23 Thread Tim Lucia
I've used a CSV JDBC driver once before with success. It becomes an exercise of reading from one JDBC connection and writing to the other. http://csvjdbc.sourceforge.net Tim (I posted this same answer on [EMAIL PROTECTED] and include it here for archival completeness.) -Original Message--

Re: Question on csv import using browser into MySQL database

2006-05-23 Thread Marc Farrow
Once you use the apache project's fileupload class you can just use a simple filereader to read through the file record by record and use the split(String regex) method from the String class to split the data into a string array. Then loop through array and write the sql statements to update your

RE: Question on csv import using browser into MySQL database

2006-05-23 Thread Juan Jose Garcia Lau
If you want to upload files, take a look at http://jakarta.apache.org/commons/fileupload/ Cheers, Juan -Original Message- From: Christopher Molnar [mailto:[EMAIL PROTECTED] Sent: Martes, 23 de Mayo de 2006 10:17 a.m. To: Tomcat Users List Subject: Question on csv import using browser