spells_new table error

[Drajor]

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

[jshows1]

Originally Posted by Drajor

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

Thanks so much for the response guys. I really appreciate the help.

Drajor that worked perfectly! Thanks for bailing me out! lol