Excel integration with databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.

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.aspx?tabid=87#OLEDBProviderForMySQL


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
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.
 
Back
Top