Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

DAO Excel - Oracle

Posted on 2000-05-05
2
Medium Priority
?
296 Views
Last Modified: 2008-02-01
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
Comment
Question by:bernjerg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 13

Accepted Solution

by:
cri earned 300 total points
ID: 2781075
0
 

Author Comment

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

Regards,
bernjerg
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question