Updating EXTERNAL databases through DAL in Excel

Thread View: comp.sys.mac.databases

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Henry K. Yu Tue, 05 Jan 1993 00:01

#572

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads