aspose file tools*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 3697
    
    5

Have you considered JDBC's batch functionality?


My Blog: Down Home Country Coding with Scott Selikoff
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: xls or csv file as in parameter in stored procedure
 
Similar Threads
text styling in csv
how to export database(oracle) data to excel..
Unable to recognize OLE stream while upload CSV
Searching and Updating a CSV file
Text file xls to Binary format xls in Java.