Of course! Here is the tutorial.

http://www.databasejournal.com/features/mssql/article.php/3507171/Transferring-Data-from-One-Table-to-Another.htm

Okay ... I think I figured it out. Thank you everybody for your input. I found a tutorial online on how to copy data from one table to...

Anthony, it can't be random numbers. There are other tables that use this ID. Here's the thing ... there IS a table on the server that is an...

That's the problem I'm having - I'm used to working with MySQL, where you CAN just add an identity field, auto-numbering field, etc., after the table has been created and...

Thanks, everyone. I'll give it a try and post back if I get stuck! Thank you!

This is what I'm doing:

1. create the database on the server.

2. click on Tables -> All Tasks -< Import Data.

3. selecting the source and destination.

4. selecting the tables I want...