software

I am wondering about the integration between Excel and an Oracle database.

What I am trying to do is develop a form that will pull data from an Oracle
view, allow for users to update information, and then save the data into
another table. Is this possible? If so, how?

Any advice would be greatly appreciated.

You can use ADO and SQL to do so.

support.microsoft.com/default.aspx?kbid=295646
How To Transfer Data from ADO Data Source to Excel with ADOsupport.microsoft.com/default.aspx?kbid=278973
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
Workbookssupport.microsoft.com/default.aspx?kbid=257819
How To Use ADO with Excel Data from Visual Basic or VBAAlso see Carl Prothman' site
www.carlprothman.net/Default.aspx?tabid=81for connection strings.
MySQL even has an OLE DB provider so you can use that rather than ODBC
www.carlprothman.net/Default....oviderForMySQL--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;JBruxerquot; gt; wrote in message
news
gt; I am wondering about the integration between Excel and an Oracle database.
gt;
gt; What I am trying to do is develop a form that will pull data from an
Oracle
gt; view, allow for users to update information, and then save the data into
gt; another table. Is this possible? If so, how?
gt;
gt; Any advice would be greatly appreciated.
I have looked through all of these articles, but I dont see any of them
providing solutions that will fit my need. Perhaps I should clarify my
question a bit. I am using odbc to connect to my oracle view. In which, I
have a form created in Excel. What I would like to do is have all values
exported into another table which I can then have a stored procedure move the
data into our main database.

quot;Bob Phillipsquot; wrote:

gt; You can use ADO and SQL to do so.
gt;
gt; support.microsoft.com/default.aspx?kbid=295646
gt; How To Transfer Data from ADO Data Source to Excel with ADO
gt;
gt;
gt; support.microsoft.com/default.aspx?kbid=278973
gt; SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
gt; Workbooks
gt;
gt;
gt; support.microsoft.com/default.aspx?kbid=257819
gt; How To Use ADO with Excel Data from Visual Basic or VBA
gt;
gt;
gt; Also see Carl Prothman' site
gt; www.carlprothman.net/Default.aspx?tabid=81for connection strings.
gt; MySQL even has an OLE DB provider so you can use that rather than ODBC
gt; www.carlprothman.net/Default....oviderForMySQL
gt;
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;JBruxerquot; gt; wrote in message
gt; news
gt; gt; I am wondering about the integration between Excel and an Oracle database.
gt; gt;
gt; gt; What I am trying to do is develop a form that will pull data from an
gt; Oracle
gt; gt; view, allow for users to update information, and then save the data into
gt; gt; another table. Is this possible? If so, how?
gt; gt;
gt; gt; Any advice would be greatly appreciated.
gt;
gt;
gt;