I have a 2010 Access database table that I need to convert over to SQL 2008 R2 database table. The table has over 10,0000 records in it.
The problem is that every time I try to transfer the data over to SQL using the Access to SQL wizard in Access it gives me an error that say "Table was skipped or export failed" which is absolutely no help at all.

Is there a way to get a more specific error to what is causing this to fail? I have also tried exporting the table to Excel and then trying to transfer the data into SQL but that doesn't give a much better error message than the Access to SQL wizard.

Please help

Thank you