When you copy a column that has an alias data type from one database to another, the alias data type may not be available in the destination database. In such a case, the column will be assigned the ...

After you provide info about the destination for your data and about how to connect to it, the [!INCLUDEssNoVersion] Import and Export Wizard shows Specify Table Copy or Query. On this page, you ...

It seems to do what we want as far as backing up a single table, however I tried copying back the data to a small table I set up to test the bcp command on, and it predictably just copies the data.

If you've been searching for a way to use the table structure in an existing Microsoft Access database in another table, then check out this quick tip. It shows how to copy and customize the table ...