Import from Excel file to Oracle Db

Advertisement

Dear all,
I am not having DBA privilege.And I cant use export utility.
I want to import the datas from Excel file through query builder. I Know there is a option in query builder. But i dont know how to do?
Plz help...
Thanks.

Advertisement

Hi,
If you are very specific to load using your tool only then below are the steps.
In the main menu
Go To Database-> Import -> Import Table Data
In the screen select your schema and table name you wish to load in.
Click on Show Data and after that click on Execute Wizard.
This will ask for table type where you can select Excel file and then follow the wizard.
Thanks.

November 30, -0001

Import from Excel file to Oracle Db

Dear all, I am not having DBA privilege.And I cant use export utility. I want to import the datas from Excel file through query builder. I Know there is a option in query builder. But i dont know how to do? Plz help... Thanks.Hi, If you are very spec

Importing date-time data from Excel file

I am running into problems importing date-times in the format 3/15/2010 9:30:00 PM using SQL Developer. At Step 1 of the Data Import Wizard, the data preview window displays all the date fields as Excel dates (e.g. 40252.89583 instead of 3/15/2010 9:

How to import an Excel file

Hi , I amwriting a BDC Program.. How to import a Excel File by Browsing the Excel file from the Directory and Storing that values in the internal table. Can any one send the code for this, Points will be awarded. Regards, Jayasimha Jangam.Hi,       C

Problem in importing from dmp file

Hi , I am facing problem while importing from dmp file on unix server Error is as follows : Export file created by EXPORT:V08.01.07 via conventional path IMP-00013: only a DBA can import a file exported by another DBA IMP-00000: Import terminated uns

How to Load the data from excel file(Extension is .CSV) into the temp.table

Hi How to Load the data from excel file(Extension is .CSV) into the temporary table of oracle in Forms11g. My Forms Version is - Forms [64 Bit] Version 11.1.2.0.0 (Production) Kindly Suggest the Solution. Regards, SachinHello Sachin, You can use the

Store data in mysql after reading from excel files

i am trying to make o program where i will read the data from excel files and i will store them in a database. I am using eclipse as editor and mySQL. I am using APACHE POI to read the excel files and JDBC for the connection. The excel files have the

Help Required:How Upload Excel file Into Oracle Table Using PLSQL Procedure

Please Help , Urgent Help Needed. Requirement is to Upload Excel file Into Oracle Table Using PLSQL Procedure/Package. Case's are : 1. Excel File is On Users/ Client PC. 2. Application is on Remote Server(Oracle Forms D2k). 3. User Is Using Applicati

How to upload the invocie verify from excel file?

How to upload the invocie verify from excel file? there is more items requied to input. refer to MIR7 thanksHow to upload the invocie verify from excel file? there is more items requied to input. refer to MIR7 thanksRead other 5 answers

Metadata from excel file

Hi we have ep6 sp16 on win2003/mssql . does anybody now how can we get metadata from excel file. meaning we want to take the list of the metadata parameter from excel file instead from csv list . Thank you Amit ZaitDoes anybody have any ideas? I beli

Data Load from XML file to Oracle Table

Hi, I am trying to load data from XML file to Oracle table using DBMS_XMLStore utility.I have performed the prerequisites like creating the directory from APPS user, grant read/write to directory, placing the data file on folder on apps tier, created

Reading the data from excel file which is in application server.

Hi, Iam trying to read the data from excel file which is in application server. I tried using the function module ALSM_EXCEL_TO_INTERNAL_TABLE. But it didn't work. I tried just reading using open data set and read data set it is giving junk character

Slow in updating price lists using import from excel

Hello, I am concerned about the slow process of updating prices in SAP using import from excel. It took me hours to complete the upload for 3700 item rows and 2 price lists. It is also slow in adding warehouses. I am not sure if the account segmentat

Function module to get data into internal table from Excel file sheets

Hi, I have to upload customers from excel file. we are donloading customer data excel file sheets. Customer data in 1 sheet, tax data the other sheet of same excel file, Customer master-Credit data in other sheet of same excel file. so i have 3-4 she

Error while uploading data to ztable from excel file

Hi, I have a requirement where i have to upload data from excel file to ztable.I have used the fm 'ALSM_EXCEL_TO_INTERNAL_TABLE' for reading the excel file.After reading the excel file i have used INSERT zrb_hdr from table t_zrb_hdr for updating the

Upload data from excel file to mii without UDS and PCo

Hi Experts, I am trying to upload data from excel file to mii db without using UDS and PCo. Is there any other ways that we can achieve it. I am thinking one solution , writing stored procedure. any other solutions? Thanks in advance, Eswar.Hi, Thank

Error importing from BIAR file (BO XI 3.0)

Dear BO community, I am using the BIAR tool for backup purposes. For my backup, I use a properties file as input which looks like the one shown below: action=exportXML exportBiarLocation=C:/Temp/BOBackup.biar userName=Administrator password=XXX CMS=X

How to transfer data from excel files into z-tables

Please help me with a code which transfers data from excel file to z-table. Thanks in advance ShuvirHi Daniel, Export Data Purpose Use this procedure to export SAP data to a local file such as Microsoft Excel. Menu Path Use the following menu path to

Images missing in numbers while imported from excel

Hey guys, I'm new here. I am having some problem with the mentioned issue, some images went missing when I import the excel file to numbers. It's an excel (.xls) file with my stock list, a lot of small images (JPG) and the whole file size is 6MB.  Th

Import from Excel to Oracle table

I have couple questions. is the 20K Excel file upload limit still apply??? I want to use APEX to upload data from Excel to Oracle, some data manipulation will be needed in the process. This will be a utility that will be used by users not DBAs or Dev

Is it possibke to extract import data from excel file not csv type

I am getting training from somebody, who is telling me the excel file has to be type csv only to extract and import the excel data for creating infoobjects, is that true. Please kindly provide steps, if any one has steps to extract the excel data whi