Hi
It will depend on how different the structures are, and where the tables are
located!
Posting DDL and example data will help to answer your question see
http://www.aspfaq.com/etiquett**e.asp?id=5006. It is also useful to post
your current attempts at solving the problem.
If your table does not contain any data and there is a simple correlation
between columns then you can use the insert statement. See Books online for
more details on the statements available and their syntax.
INSERT INTO Table2 ( ColX, ColY, ColZ )
SELECT Col1, Col2, Col3
FROM Table1
If your tables are on different machines or if this is a regular task then
you may want to use DTS or possibly BCP.
John
"thaar al_taiey" <th***@hotmail.com> wrote in message
news:42**********@127.0.0.1...
hi their,
How can i copy data in MS-SQL 2000 from one table to another with
different charactristic?
thanks
*** Sent via Developersdex http://www.developersdex.com ***