I am working on upsizing an MS-Access database from Access 2010 to MS-SQL 2008 (10.0.1600). When I run the Upsizing Wizard, all the tables get moved over except for one...
The table that doesn't get moved has ~18,000 records and many of the column names have spaces in them. I am just unsure of how to find out why the table is not getting moved. The error that I receive only tells me that "Tab was skipped, or export failed." I don't know how to get Access to provide me with a more useful error than that.
So far I have confirmed that the error is not being caused by:
- Invalid data types (yes/no, date, etc.)
- Spaces in column names