This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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: 3703
    
    5

Have you considered JDBC's batch functionality?


My Blog: Down Home Country Coding with Scott Selikoff
 
Don't get me started about those stupid light bulbs.
 
subject: xls or csv file as in parameter in stored procedure
 
Similar Threads
Unable to recognize OLE stream while upload CSV
how to export database(oracle) data to excel..
Searching and Updating a CSV file
text styling in csv
Text file xls to Binary format xls in Java.