472,354 Members | 2,095 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,354 software developers and data experts.

Loading Excel File into Oracle Table

19
Hi,

I need to create a script [preferably Unix+sqlldr] to load Excel file into oracle tables. Please help if you have worked on anything like this. I have been doing this converting Excel to CSV manually and then running the script(sqlloader). Is there a script which can automate this process.

Thanks
Ravi
Aug 1 '08 #1
6 4471
debasisdas
8,127 Expert 4TB
from what source you are creating the excel sheet ?
Aug 1 '08 #2
raviva
19
I download the file from a website, it will be in excel format. then i save it as csv and then ftp it to unix box and run the sqlloader...

from what source you are creating the excel sheet ?
Aug 1 '08 #3
raviva
19
Any idea on this??

Ravi


I download the file from a website, it will be in excel format. then i save it as csv and then ftp it to unix box and run the sqlloader...
Aug 5 '08 #4
amitpatel66
2,367 Expert 2GB
SO what is the problem now??
Is your sql ldr not uploading the data properly or something??
Aug 5 '08 #5
raviva
19
All I am doing is downloading the excel file and converting the excel file into CSV(manually). I wanted to know is there a automated process which converts the excel file into csv?

SO what is the problem now??
Is your sql ldr not uploading the data properly or something??
Aug 5 '08 #6
amitpatel66
2,367 Expert 2GB
All I am doing is downloading the excel file and converting the excel file into CSV(manually). I wanted to know is there a automated process which converts the excel file into csv?
No there is no such automated process as such.Did you try save as .csv when you download from the server and use that file for uploading data?
Aug 5 '08 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Ornez | last post by:
Hi, I need to enable the IE user to upload/select a file .Then i have to validate the data and put it in a grid/table . Using input type=file will save it on the server where there is no need...
0
by: dioscuroi | last post by:
When I call OCI (Oracle Call Interface) functions in Debug mode of VC+ 7.0, it takes too much time to load oracle debug symbols, and finall failed. Error messages are printed in output window, just...
3
by: Conrad F | last post by:
Hello All, I know how to import a specific named excel sheet into a datagrid using ADO.NET by setting up a JET connection and then SELECTing data from the sheet. However, for a real world...
0
by: ramnaresh_t yadav via .NET 247 | last post by:
Hi, I am pasting the code to import data from Text/Excel files into Database(Oracle ) Table... I think some one needs this .. they can use.. it... ======================= Dim dsDB As New DataSet...
3
by: natrajsr | last post by:
Hi, I want to load the data of a excel sheet or in the exact excel sheet format into a Rich TextBox control. I have already worked with loading WORD into a Rich TextBox. It is working fine.;...
3
by: jelinjose | last post by:
Hi, I have created a table with table name T1 with a particular schema. I have entered the data in an excel sheet in the particular schema above and saved as T2.dmp file. I would like to know...
0
by: wankhusairi | last post by:
hallo sir .. i am still new on using vb and i have tried to load an excel using a visual basic interface.. but if i wanted to plot my excel data what should i do.. must i cahnge my program on loading...
0
VietPP
by: VietPP | last post by:
Hi all, I need to get some data in an excel file and then update them into a table in OracleDB. Please, anyone have experience in this case can give me a help! ==== Example: Oracle Table:...
1
by: hvellani | last post by:
Okay here is my problem... I have multiple csv files with data in each file. They are connected via foreign keys (with each table having its on primary key). I want to load these tables into an...
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made but the http to https rule only works for...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.