Error while exporting SQL Server 2000 data to excel through DTS -
03-20-2009
, 09:10 PM
I am getting a strange error after some XP build updates on my machine. I
have a MS Access application (Front End) and back end is SQL Server 2000.
The table data is exported to excel from MS Access using a DTS package file
using ADODB.
The error I am getting is "The number of failing rows exceed the maximum
specified and database is read only", where as when I run the package from
Enterprise Manager it works fine.
I tried to debug the problem but it fails at DTS.execute procedure.
Any suggestions?
--
JimGeo |