April 16, 2004 at 11:57 am
Hello, I am new to this so I hope I am asking the right question in the right place. I would like to copy the data from one table to another table.
Thanks for the help,
Frank
April 16, 2004 at 12:31 pm
1. Gain basic SQL knowledge.
You may "copy" data from one table to another using the INSERT statement or perhaps use SELECT INTO.
2. In SQL Server you may also use DTS ( Data Transformation Services ). Using the "Transfer Data Task".
Tip - use dtswiz, just Click "run", type dtswiz, and follow the wizard.
3. Use the bcp utility ( commandline ) to copy the data in the table to a textfile and use bcp ( or BULK INSERT ) to get the data from the textfile into a table. - This you would do if the tables are located on two different sql servers which cannot connect to each other for some reason.
/rockmoose
You must unlearn what You have learnt
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply