Re: import excel files
From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Tue, 19 Feb 2002 17:58:27 GMT
Message-ID: <3C729252.E6F5607F_at_ci.seattle.wa.us>
Date: Tue, 19 Feb 2002 17:58:27 GMT
Message-ID: <3C729252.E6F5607F_at_ci.seattle.wa.us>
Lots of hacking around. You mean like reading the manual? <g>
Save the spreadsheet as a CSV. Then you can import it using SQL Loader or UTL_FILE. Daniel Morgan
Steven Pannell wrote:
> Hi,
>
> I'm using Oracle 8i and I am wondering if there is a tool available where I
> can easily import excel sheets directly into and Oracle datebase table. In
> SQL Server this is very easy but I don't see an easy way of doing this in
> Oracle without a lot of hacking around.
>
> thanks for any help,
> regards,
> Steve.
Received on Tue Feb 19 2002 - 18:58:27 CET