I am unable to get the access 2000 import tool to work (full, paid version). It starts fine then fails at 176 records (out of 760). The error that is displayed on the page is this:
Microsoft OLE DB Provider for SQL Server error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/forum/admin_import_members.asp, line 427
If I try it again (assuming that it will ignore duplicate records), the import gets thru about 15 records and I get this error message:
Microsoft OLE DB Provider for SQL Server error '80040e2f'
Cannot insert duplicate key row in object 'dbo.tblAuthor' with unique index 'Username'.
/forum/admin_import_members.asp, line 454
Does anyone have any suggestions?
Thanks,
Joe
Topic Options
Post Options
Thanks(0)
