I would never do this with a wizard normally but I decided to check it out. I was able to export and and import a table with a bit of messing around, below was my method.
(PHEW). So I messed around a bit longer, XML is much easier than TXT.
- Right click table X -> Export Wizard
- Step 1: Choose 'XML file'.
- Step 2: Choose a filename.
- Step 3: Leave as default.
- Step 4: Uncheck 'Continue on error'.... Check 'Include column titles'.
- Step 5: Start!
- Right click table X -> Import Wizard
- Step 1: Choose 'XML file'.
- Step 2: Select your export file.
- Step 3: Select 'RECORD'
- Step 4: Leave as default.
- Step 5: Leave as default.
- Step 6: Leave as default.
- Step 7: Select 'Copy: delete all records in destination..'
- Step 8: Start!
Assuming there are no schema changes this should work for you. If not, we will try something else
