Re: Any tools to transfer files/data between Oralce & Excel

From: Hari Vattyam <hvattyam_at_one.net>
Date: 1998/03/04
Message-ID: <34fdb956.0_at_news.one.net>#1/1


Hi:
You could use powerbuilder's pipe object to do the transfer. Basically you would
set up ODBC sources for Excel and Oracle. Also in the Spreadsheet make sure that the column formats are defined correctly (Oracle supported). Then use the Excel sheet as source for your pipe and Oracle as the destination.
Another alternative is to Import the Excel sheet into MS Access. Then you can export the table from Access directly into Oracle. Hope that helps,
Hari

Bharani wrote in message <34FCC916.4C36_at_ApnaWeb.com>...
>Hello,
>
>We need to transfer data between Excel & Oracle directly with/without
>Sql*Loader. Are there any tools to do that?
>
>Would doubly appreciate if you could reply to Logo_at_ApnaWeb.com
>
>Thanks,
>Logo Palanisamy
>Logo_at_ApnaWeb.com
Received on Wed Mar 04 1998 - 00:00:00 CET

Original text of this message