Re: Data input
Date: 1998/02/17
Message-ID: <6cc0c6$dl6$1_at_nnrp1.dejanews.com>#1/1
You certainly can.
I made a tool which can do this. It's called Oraxcel and you can download a lite version from my site (demo of the insert feature is included).
Point your browser to http://members.aol.com/gjlinker
Oraxcel comes about as a new menu item in Excel. Clicking the Excel menu item Oracle-Data Entry will popup a little box where you can input the table name. It sets off and creates a little spreadsheet with a table in which you can put your data. Simply click insert and there goes !
Gerrit-Jan Linker
In article <34DF5728.5D16A0CE_at_cs.uno.edu>,
Srikanth Patibanda <spatiba2_at_cs.uno.edu> wrote:
>
> hello,
>
> currently iam using Developer 2000 on win95 and as my database iam using
> personal oracle 7.
>
> i created some tables in the database(at sqlplus prompt).
>
> i have the data files in the excel..
>
> can i read excel and insert those data into the oracle database..
>
> i really appreciate for the help.
>
> truly
> srikanth
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Feb 17 1998 - 00:00:00 CET