?
Solved

DAO Excel - Oracle

Posted on 2000-05-05
2
Medium Priority
?
299 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
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This tutorial summarizes the causes behind"an unknown error prevented access to the PST File”.  It also suggests the various solutions to fix the problem.
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

589 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