Use BCP and the -N option for the native format. As long as both tables
have the exact same structure you should be all set. Check out BCP in
booksOnLine. And by the way, Excel is one of the worst formats for
transferring data and should be used only when necessary.
Andrew J. Kelly
SQL Server MVP
"Sender" <userdomain.com> wrote in message
news:045201c340f8$76f412c0$a501280aphx.gbl...> In my SQL Server 2000 (which is installed on my PC which
> is in Office) there is one table with following structure:
> Id char 7
> Description char 255
> EntityID char 47
> vdata image 16
> tstamp timestamp 8
> This table has more than 1000 records.
> I have another SQL Server 2000 (which is installed on my
> PC at home) which also contains the similar table with the
> similar structure. This table has zero records.
> If there were only numeric or string or date type data I
> would have exported (from Office SQL Server) them using
> DTS into Excel and would have imported that Excel file
> using DTS in my Home computer.
> But as you can see above this table contains image and
> timsestamp datatype.
> My office SQL Server and home SQL Server can't be
> connected directly.
> What's the easiest way to populate my home SQL Server
> table with the records of office SQL Server table.