Excel integration with databases

[JBruxer]

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.

[Bob Phillips]

You can use ADO and SQL to do so.

http://support.microsoft.com/default.aspx?kbid=295646
How To Transfer Data from ADO Data Source to Excel with ADO


http://support.microsoft.com/default.aspx?kbid=278973
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
Workbooks


http://support.microsoft.com/default.aspx?kbid=257819
How To Use ADO with Excel Data from Visual Basic or VBA


Also see Carl Prothman' site
http://www.carlprothman.net/Default.aspx?tabid=81for connection strings.
MySQL even has an OLE DB provider so you can use that rather than ODBC
http://www.carlprothman.net/Default....oviderForMySQL


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"JBruxer" <[email protected]> wrote in message
news:[email protected]...
> 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.

[JBruxer]

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.

"Bob Phillips" wrote:

> You can use ADO and SQL to do so.
>
> http://support.microsoft.com/default.aspx?kbid=295646
> How To Transfer Data from ADO Data Source to Excel with ADO
>
>
> http://support.microsoft.com/default.aspx?kbid=278973
> SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
> Workbooks
>
>
> http://support.microsoft.com/default.aspx?kbid=257819
> How To Use ADO with Excel Data from Visual Basic or VBA
>
>
> Also see Carl Prothman' site
> http://www.carlprothman.net/Default.aspx?tabid=81for connection strings.
> MySQL even has an OLE DB provider so you can use that rather than ODBC
> http://www.carlprothman.net/Default....oviderForMySQL
>
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "JBruxer" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>