<div>
I still have a few pages left to read, but it seems like I'll find the answer here!!<br />
<br />
Regards,<br />
bernjerg
</div>


I still have a few pages left to read, but it seems like I'll find the answer here!!

Regards,
bernjerg

<div>
<div class="content wysiwyg-content">
Hi!<br />
<br />
I need some help interacting between an Excel spread sheet and an Oracle database. Retrieving data from the database to Excel with QueryTable.Add works fine, but not when I want to modify data in the spread sheet and then return the data back to the database. I guess I'll have to refer to the DAO add-in and declare a ODBC connection. I hope someone has a good idea of how this can be done.<br />
<br />
Regards<br />
bernjerg
</div>
</div>


Hi!

I need some help interacting between an Excel spread sheet and an Oracle database. Retrieving data from the database to Excel with QueryTable.Add works fine, but not when I want to modify data in the spread sheet and then return the data back to the database. I guess I'll have to refer to the DAO add-in and declare a ODBC connection. I hope someone has a good idea of how this can be done.

Regards
bernjerg

DAO Excel - Oracle

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.