You can create an access db that acts as a passthrough from excel to
oracle, access uses the odbc driver and excel is using the ole method (or
something like that). Works well once you get it going
l-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 18 de Marzo de 2002 10:44 a.m.
Para: Multiple recipients of list ORACLE-L
Asunto: Excel to Oracle
Hi All,
What is the best/quickest way to move data from excel to Oracle?
Thanks
Rick
--
Please see the official ORACLE-L
I would dump the excel sheet to a text file and use SQL*LOADER to move it
into Oracle.
Alec
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, March 18, 2002 7:44 AM
To: Multiple recipients of list ORACLE-L
Hi All,
What is the best/quickest way to move data from excel to Oracle
Extension 8487
-Original Message-
Sent: Monday, March 18, 2002 7:44 AM
To: Multiple recipients of list ORACLE-L
Hi All,
What is the best/quickest way to move data from excel to Oracle?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL P
ACLE-L
Hi All,
What is the best/quickest way to move data from excel to Oracle?
Thank
http://www.oraexcel.com
-Original Message-
[EMAIL PROTECTED]
Sent: 18 March 2002 15:44
To: Multiple recipients of list ORACLE-L
Hi All,
What is the best/quickest way to move data from excel to Oracle?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Title: RE: Excel to Oracle
hi!
i would probably just export the table in a "portable" csv
format and then use the oracle sql*loader to import it into
oracle. simple but it works!
cheers
dieter
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Se
Hi All,
What is the best/quickest way to move data from excel to Oracle?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
se
> SQLLoader,
> > please be informed that there are 2 product which are able to handle
your
> > requirement. One is SecondWind and the second is Oraxcel.
> >
> > Regards,
> > Pierre
> >
> > -----Original Message-
> > From: ravindra [SMTP:[EMA
quirement. One is SecondWind and the second is Oraxcel.
> >
> > Regards,
> > Pierre
> >
> > -----Original Message-
> > From: ravindra [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, March 29, 2001 8:46 PM
> > To: ORACLE-L
> > Cc: ravindra
> &
L PROTECTED]]
> Sent: Thursday, March 29, 2001 8:46 PM
> To: ORACLE-L
> Cc: ravindra
> Subject: Excel to oracle
>
> I have a Excel file.How to port the data to Oracle table.
>
> I read some artical about using ODBC and things like that.But
> I am not clear.
>
> How ca
ent: Thursday, March 29, 2001 8:46 PM
> To: ORACLE-L
> Cc: ravindra
> Subject: Excel to oracle
>
> I have a Excel file.How to port the data to Oracle table.
>
> I read some artical about using ODBC and things like that.But
> I am not clear.
>
> How can we gener
PROTECTED]]
Sent: Thursday, March 29, 2001 8:46 PM
To: ORACLE-L
Cc: ravindra
Subject:Excel to oracle
I have a Excel file.How to port the data to Oracle table.
I read some artical about using ODBC and things like that.But
I am not clear.
How can we generate a dat file delimited
make a tab delimited file and use chr(9) as the delimiter in the control file.
>>> [EMAIL PROTECTED] 03/29/01 04:15PM >>>
Thanks for all the replies.
I am able to load data to the table.the table is having a number column and
a varchar column.
In the varchar column *some* records are being inser
Thanks for all the replies.
I am able to load data to the table.the table is having a number column and
a varchar column.
In the varchar column *some* records are being inserted with double quotes
at the beginning and
end of the data feild and all witha comma as the end.I don't want these
double
I have to do this all the time. But, I also have MS Access on my PC, so I
import the Excel file to Access (as a table)
and then export this table using ODBC to my oracle database.
You will need to download ODBC drivers for your P.C..
- Original Message -
To: "Multiple recipients of list
Use the save as option in Excel and save as a comma or tab delimited text file. In
other words a CSV or TXT file. The CSV is comma delimited, the TXT is tab delimited.
SQLLOADER can use either (with the correct control file)
>>> [EMAIL PROTECTED] 03/29/01 01:46PM >>>
I have a Excel file.How to
Ravindra,
The first thing you need to do is convert the Excel file to CSV. Do this by
opening the Excel file, do a "FILE | SAVE AS" and select "File Type" CSV.
This will create you CSV file!
Ed Haskins
Oracle DBA
Verizon Wireless
-Original Message-
Sent: Thursday, March 29, 2001 1:46
I have a Excel file.How to port the data to Oracle table.
I read some artical about using ODBC and things like that.But
I am not clear.
How can we generate a dat file delimited with comas so that I can
use SQlLOADer to port the data.
Thanks
Ravindra
--
Please see the official ORACLE-L FAQ: h
You can save the Excel file in comma delimited formated, CSV and use
sql*loader to put the data into the database. You can just ftp it from the
machine which has Excel to the server housing the database.
HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PR
20 matches
Mail list logo