Copying Data

Hi all,
Can i do have two different databases[onse server]. I need to
copy the data from one table to another table[another database].
I dont want to recreate the table, i need to copy only the data how is
it possible?
Thanks in Advance
thomsonINSERT INTO db1.dbo.TableName
SELECT <collist>
FROM db2.dbo.TableName
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"thomson" <saintthomson@.yahoo.com> wrote in message
news:1122276930.267683.324740@.g49g2000cwa.googlegroups.com...
> Hi all,
> Can i do have two different databases[onse server]. I need to
> copy the data from one table to another table[another database].
> I dont want to recreate the table, i need to copy only the data how is
> it possible?
> Thanks in Advance
> thomson
>|||hi thomson,
You can select Export Data option from All tasks submenu or write a simple
DTS.
regards,
"thomson" wrote:

> Hi all,
> Can i do have two different databases[onse server]. I need to
> copy the data from one table to another table[another database].
> I dont want to recreate the table, i need to copy only the data how is
> it possible?
> Thanks in Advance
> thomson
>|||All solution are fine , but if u wanna do that
open tbl in one database showing all data
Select all data copy it and paste into the destination table
i hope it will work|||hi saurabh,
That's a good solution without a doubt but that will fail if the table own a
identity field.
Regards,
"Saurabh" wrote:

> All solution are fine , but if u wanna do that
> open tbl in one database showing all data
> Select all data copy it and paste into the destination table
> i hope it will work
>