You could write a VB script that opens both databases, reads a row from one, and writes the row to the other...
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gordon Frank Sent: Wednesday, September 05, 2007 7:49 AM To: [email protected] Subject: Import into MS Access through a Remedy ARS Button and Active Link I tried this once with no response. I'll try it again. Hello, Has anyone done an import of MS Access from an Active Link? I believe you can do it through series of DDE actions, but I'm having trouble with the right combination. I believe the first one has to be [OpenDatabase "database"], and the following actions should include a TransferText, etc. Do I have to save a .csv file first? I know this all works with the DoCmd actions, but I do not have a good template for such an import. Does anyone have a template or documentation that they can share? Thanks, Gordon M. Frank EDS/NMCI ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
