Exforsys

Free Training

Load data from csv file to oracle database using sql scripts

This is a discussion on Load data from csv file to oracle database using sql scripts within the Java forums, part of the Programming Talk category; I have already convert excel file into csv. in my csv file data is from different different tables. i used ...

Go Back   Exforsys > Programming Talk > Java

Exforsys.com

  #1 (permalink)  
Old 04-08-2009, 08:22 PM
Junior Member
 
Join Date: Apr 2009
Posts: 2
Namarta is on a distinguished road
Load data from csv file to oracle database using sql scripts

I have already convert excel file into csv. in my csv file data is from different different tables. i used string token to convert excel to csv. can anyboby please provide me the code in java to load this csv data into oracle database in different tables.i mean how i will define a particular field data will insert into related table. I have to submit this code tommorow please reply soon.


Thanks in advance
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 04-15-2009, 07:43 AM
Senior Member
 
Join Date: Mar 2005
Posts: 916
techguru is on a distinguished road
why don't you use sql loader to do this
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
Tutorial on Silk Test spriya279 Testing Tutorials 2 02-15-2007 06:31 PM
Comp.software-eng FAQ (Part 0): periodic postings and archives David Alex Lamb Tech FAQ 2 05-23-2004 05:15 AM
Apple II Csa2 FAQs: Uploading & Downloading, Part 21/25 rubywand@swbell.net Tech FAQ 0 05-04-2004 09:01 AM
Comp.software-eng FAQ (Part 0): periodic postings and archives David Alex Lamb Tech FAQ 3 04-18-2004 05:15 AM
[FAQ] FileMaker Pro - database for Macintosh and Windows Martin Trautmann Tech FAQ 0 04-17-2004 07:26 AM


All times are GMT -4. The time now is 03:46 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.0
Copyright 2004 - 2009 Exforsys Inc. All rights reserved.