Re: Automate Data Entry

Hi,

If you want to load the Excel data into Oracle my Oraxcel utility could be of help. It is an addin for MS Excel and loads data into Oracle.

Have a look at http://members.aol.com/gjlinker/projects/oraxcel for a detailed description.

Here is the list of features:

• Query Oracle and receive the data in your spreadsheet.
• Fetch data into Excel, change it and post the changes back to Oracle.
• Browse your Oracle tables and columns.
• Execute PL/SQL.
• Load a full spreadsheet of data into Oracle in one go.
• Commit or Rollback transactions.
• Installation spreadsheet provided.
• Assign the return value of an Oracle query to a cell in Excel.
• Oraxcel provides a form to do inserts and updates or to make insert scripts.
• Use Excel formulae to assemble (pl)sql.
• Refer to Excel cells in your (pl)sql. e.g. select * from emp where sal > :B4
• Use SQL and PL/SQL from a selection in the spreadsheet
• Oraxcel let you automatically connect to Oracle from an Excel script.
• Execute (PL/)SQL from an Excel script.

Regards, Gerrit-Jan Linker

In article <366f2eb3.0_at_news1.ibm.net>,   <jgabany_at_ibm.net> wrote:
> This is not a true Oracle question but it will help in our Oracle
> Manufacturing App's implementation. We are in the progress of implementing
> Oracle Manufacturing Apps (leaving behind our legacy system). We were able
> to convert much of our legacy data and import into the Application tables.
> However we have a significant amount of data that has to be entered
> manually. It is not cost affective to develop a programmatic solution (it's
> broken into many small unrelated pieces of information and will not be
> re-used).
>
> We have created several spreadsheets documenting the information that needs
> to be entered. Is there a "macro builder" we can use to pull this
> information from the spreadsheets and navigate the Oracle Forms to input the
> information?
>
> thanks
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Dec 19 1998 - 17:33:11 CET