You can do this several ways. One way is to use the "Expor" utility. Right click on the table, and select "All Tasks", "Export Data". This is good if you want to move a lot of records. Of couse, the receiving table will have to be the same as the table you are exporting from.<BR><BR>Also, if the tables have the same schema, you can select individual records, CTRL-C, then go to a new row in the other table and paste it. I does this sometimes.
The table I want to copy from has one column, and the table I want to copy to has around 10 columns. I want to move the data from the first table into a specific column in the second. I tried doing this w/ an ASP Script but the script wouldn't run because there's 3000 records in the first table...<BR>Is there any other way?<BR>Thanks - Trevor