Using JSP to upload a CSV to update database
843836Jul 27 2004 — edited Nov 23 2008Hey ppl, need your advise here.
Is it possible and what method would you use to...
1) Upload a CSV file thru a JSP page then...
2) Use the data in the CSV file to update the database?
EXAMPLE
A database with a table1 that contain a list of barcode and its description
TABLE 1
------------
Barcode1 Towel
Barcode2 Soap
I want to upload a csv file thru a JSP where it will read it data, match the barcode in table1 and update its description.
CSV
-------
Barcode1 Towel (Red)
Barcode2 Soap and Toothpaste
What is the advisable way to do it? Thanks in advance...