Excel to Oracle - Need recommendation

[mrpaulwass]

Are there any recommended methods/tools for taking data from a spreadsheet to an Oracle database?

We have spreadsheets with tens of thousands of rows and want to be able to use a tool to assist in this process.

We also didn't want to use SQL*Loader. We were looking for a user friendly way of doing this. Something that ties into Excel would be nice.

Are they any other front end tools which have excel like capabilities which can take data directly back to the database?

Thanks for the help.

Paul

[stecal]

SQL*Loader is hard to use?

[vanirame]

I also need some tool for this.Looks like DBA need to know VB.
One expert's answer
http://asktom.oracle.com/pls/ask/f?p...D:243814703172

[sanjay92]

What about Oracle 9i ETL ( External Tables). I am not sure what oracle version you are using.

Sanjay

[xyz2000]

you can use OEM tool (load wizard) to load the data.

[sjadhavdba]

i use Oracle 8i.

to transfer the data from spreadsheet to Oracle tables i use MSACCESS.

1. Open MSACCESS
2. Import Excel Spreadsheet
3. Export the table using ODBC to Oracle table.

DSN should be created for Oracle user in which you have to import the data.

[sjadhavdba]

SQL Loader is also quiet good to use.

Depends upon you whether to use or not,

[mbawa]

You can use EXCEL'S DATA-> get external data option to get data using ODBC.You can choose tables and columns graphically using that

[KenEwald]

I think "Second Wind" is what you're looking for... I used this excel add-in years ago and was really impressed with it.

http://www.dataeasier.com

The following is from their site:

A seamless link is created between a user's Microsoft Excel session and an Oracle DBMS

Users can Access, Manipulate and Update Oracle data with the convenience and power of Microsoft Excel

Second Wind™ provides all the tools you need to make life easier, including a query builder to aid in SQL statement creation and functions for advanced users to incorporate into excel macros for rapid application development.

[mrpaulwass]

Ken,

Thanks very much.

And thank you everyone else for you input.

Paul