Tables not copied when converting from Access to a SQL Server Database
This usually means that the original Access database is corrupt. Use the following techniques to solve the problem:
- Repair and compact the Access database using the Database Maintenance Utility.Use the copy tool to copy the Access database into a new Access database and only commit one record at a time (use Options->Configure and change the "Number of records to commit" value to 1).Perform another repair and compact and attempt the conversion again.
Old KB# 10591