Well, my friends, I am not about to learn another API set. If anyone knows how to do the same way in Sybase, I am all ears. So if you get errors, check the settings first. Another common source of errors is that the fields in the source data do not match the fields in the target table. SourceRecordset property must be passed a recordset that matches the target table.
Updates are too slow.
You may be trying to insert into a database that is almost full and it has to grow itself for each insert. Or you maybe inserting into a table that has a clustered index. This means that for each inserted row the database has to resort the table. You are getting data errors - some rows do not want to insert themselves. Make sure you know what you inserting and where.