Re: Importing external data into tables....??

From: Kevin Kirkpatrick <kjk_at_hrb.com>
Date: Mon, 28 Sep 1998 08:00:25 -0400
Message-ID: <360F7A59.318DF7EE@hrb.com>

This can be done very easily. This is how I did it. Do you have Access also? If so, you can take the spreadsheet into access and then use ODBC to get it into Oracle. But to do this you will have to have the ODBC drivers installed and SQL*NET. I was working on an NT machine getting data onto an Oracle database on UNIX. It worked great and very fast. We explored other options such as using Visual Basic to do the ODBC call and it was slow. MS-Access worked fine though.

Good luck
kevin

Ienaris wrote:

> Hi...
>
> I've got an EXCEL 97 worksheet with all user names in the
> organization and I would like to import them into a USER
> table. Would appreciate any assistance as to how I could go about
> doing this. Any tools that are available in Oracle ??
>
> Pls mail to <valigean_at_post1.com>
>
> Thanx.
Received on Mon Sep 28 1998 - 07:00:25 CDT