When Insert rows from VBA in Excel into a SQL Server table the trigger for insert doesn't work in DB

[Gonfer]

Hi guys,

I have a form in Excel with a button for inserting data to a SQL table. The insertion works fine, the row is inserted successfully but the trigger related to my table in my database doesn't work, however when I perform any insertion working in my SSMS the trigger works fine!. I need that the trigger works when I insert any row from excel.

Anybody has had a similar issue working with data inserted from Excel/VBA to SQL server?

Please, I would appreciate any advice. Thank you very much in advance!!!!

GonFer

 

[gmmastros]

Can you show the code for the trigger that is misbehaving?


-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Andrzejek]

Cross-posted in thread707-1768859

Have fun.

---- Andy

There is a great need for a sarcasm font.