wood burning stoves*
The moose likes JDBC and the fly likes xls or csv  file as in parameter in stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "xls or csv  file as in parameter in stored procedure" Watch "xls or csv  file as in parameter in stored procedure" New topic
Author

xls or csv file as in parameter in stored procedure

ajse ruku
Ranch Hand

Joined: May 06, 2005
Posts: 193
Hi,
Please let me know if its possible to pass xls or csv file to a stored procedure. Stored procedure will then read the records and insert into a table. I want to do this because file is too large and processing records in java takes very long time.
regards,
Ajse
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3700
    
    5

Have you considered JDBC's batch functionality?


My Blog: Down Home Country Coding with Scott Selikoff
 
jQuery in Action, 2nd edition
 
subject: xls or csv file as in parameter in stored procedure
 
Similar Threads
how to export database(oracle) data to excel..
Unable to recognize OLE stream while upload CSV
Searching and Updating a CSV file
text styling in csv
Text file xls to Binary format xls in Java.