Hi =?Utf-8?B?bnljZG9u?=,
can i use automation from an Excel form, to append a row to an Access table?
If so, can you point to any code samples if you know of?
Yes, you can. It involves using either DAO or ADO to link to the data table.
It's possible to write the information directly into the recordset, or to use a
query. Here's an article that discusses some of the basics of ADO in connection
to Access and Office
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/de
ovrusingadotoworkwithaccessdatabases.asp
The best place to pursue this is probably an ACCESS newsgroup, as those people
will have the most experience with what you want. You should tell them
- the version of Office involved
- more details about your requirement, such as the frequency with which the
update should occur. The location of the database (on your local machine, on a
network, other). How many people could be using the solution. Anything else
that might be relevant.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail
