Updating EXTERNAL databases through DAL in Excel

Article View: comp.sys.mac.databases

Article #572

Back to comp.sys.mac.databases Previous Next

#572

From: Henry K. Yu
Date: Tue, 05 Jan 1993 00:01

19 lines
1169 bytes

Does anyone know if it is possible to have Excel update External database
through DAL on the Mac?  It can query and paste data from the External
database with no problem.  But, I can't find any documentation as to if it
is possible at all.  The external database is an Oracle 6 database on a VAX.

I tried issuing the SQL statement 'insert into emp values (...);' in the
query tool of Excel.  It doesn't work that way.

I tried using the Data Form of Excel also.  Excel complains that Forms can't
be used with External database.

If it is not possible directly, has anyone tried writing a Macro of some kind?
Any hint or example or information is very much appreciated.

Happy New Year,
hyu

hyu@eng.umd.edu
hyu@author.gsfc.nasa.gov

Technical Details

Message-ID: <1993Jan05.000153.27490@eng.umd.edu>

Path: arc1-ca.pugleaf.net!sparky!uunet!spool.mu.edu!enterpoop.mit.edu!mojo.eng.umd.edu!hyu

Show Full Headers

Complete Article Headers

Newsgroups: comp.sys.mac.databases
Path: arc1-ca.pugleaf.net!sparky!uunet!spool.mu.edu!enterpoop.mit.edu!mojo.eng.umd.edu!hyu
From: hyu@eng.umd.edu (Henry K. Yu)
Subject: Updating EXTERNAL databases through DAL in Excel
Message-ID: <1993Jan05.000153.27490@eng.umd.edu>
Date: Tue, 05 Jan 93 00:01:53 GMT
Organization: Project GLUE, University of Maryland, College Park
Distribution: usa
Keywords: DAL, Excel, Oracle
Lines: 20