Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel integration with databases
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel integration with databases
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" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel integration with databases
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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Excel and Databases | Excel Discussion (Misc queries) | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |