• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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