Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

DAO Excel - Oracle

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
0
bernjerg
Asked:
bernjerg
1 Solution
 
criCommented:
0
 
bernjergAuthor Commented:
I still have a few pages left to read, but it seems like I'll find the answer here!!

Regards,
bernjerg
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now