when I use
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, strTable, strPath, -1
after completing importing, the Excel Application ( In Task Manager,XP) is still running in background. How can I close the Excel Application which is running in background?
Thanks
Sammidi Anil
I have a trigger for Insert and Update on Table1 which updates or Inserts rows in Table2.
like
"
CREATE TRIGGER [Trigger1] ON [Table1]
FOR INSERT , UPDATE
AS
BEGIN
insert into Table2(Step, Executed) values ('r','1')
END
"
If I insert one row at a time the trigger is working fine.
But when I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.