I'm trying to export data from a AC

[wawer]

I'm trying to export data from a ACCESS 2000 table to another SQL server 7.0 table with the same table name and to keep a trigger on the SQL Server table working on insert. But it doesn't work.
Do you have an idea?
Thank you for advices.

 

[RickCole]

Copy the table into SQL Server with a diffrent name and then use SQL to insert the rows into the correct SQL table.

Triggers are disabled when importing data like you trying to do from Access.

Rick.