Excel to Oralce
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   Balaji_Raguraman
Posted On:   Wednesday, April 11, 2001 07:42 AM

I need to export data from an Excel Spreadsheet to Oracle(I am using VAJ/WebSphere). I have the idea that this needs to be done by having a Tab Delimited Excel(text) file and transporting it to the Database Server and then writing a control file. Also there needs to be a cron-job / Sql Loader command to push data to Oracle. Just wanted to know the details of this since I am a Java person and dont have so much knowledge about PL/SQL. Does this job need an Oracle PL/SQL programmer's help or can it be done by me myself? Please do get back to me with this(bal_balaji@hotmail.com). Thanks in advance.

Report | Quote This | Send private message | Reply | Print

Re: Excel to Oralce

Posted By:   P_Manchanda  
Posted On:   Friday, August 17, 2001 05:00 AM

hi,
one way to avoid a pl/sql program that i can of is to read the tab delimited excel file through a java program,
form a query of the data to be inserted and then execute the query from the java program.I hope u must be knowing the database details like sid, table name and field names.


let me know if it works
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact