Looking For a Data Import Utility

5/12/02 | Self

[lafroste]

Does anyone know of a shareware/freeware/ or commercial product that can automate the process of retrieving a set of data from a relational database or a comma delimited file or spreadsheet (ie. Excel) then populating all relevant data fields into a an Oracle Application form?

I would also appreciate any comments on experiences others may have had with such products, and any good informational websites that may discuss these types of programs. Thanks!

[Cagey]

You're in the wrong forum for something as complicated as that. There's only about 43 Freepers who read the posts in the General Interest forum and most of us are dolts. If you had posted this on the main forum you'd have quite a few responses and your answer by now.

[riley1992]

and most of us are dolts

Speak for yourself. I come to this side for the intellectually stimulating conversation.

[Cagey]

I did say "most", not all.. Hahaha

[Cagey]

Many located here

[riley1992]

Now you've gone and done it. You just lost your dolt status by posting that link. Over to the smart people side with you, buddy.

[Cagey]

Keep an eye on my hat til I get back, if you would.

[riley1992]

[D-fendr]

If you need something in addition, to the products linked by Cagey, I've had good experience with using Filemaker as a customizable data manipulator.

For example, if you needed to parse or massage the data from its Excel source, you can import it into Filemaker, make use of a robust set of easily-designed database tools and export it in a wide range of formats; there's also ODBC and some SQL support.

We've used it quite a lot in this area and it can be very handy.