Export/Import

Hi,
We are using SQL server at Factory and HeadOffice and both are not
linked,
We want to send some data from HO to Factory's Sql server and vice
versa through CD/Floppy.
How to do this ?. (Export/Import) .
Can be do this using programming?
Please reply back
Please also let me know good source for advance Level programming for
SQL Server
Thanks in advance
Vivek Bharadwaj
Data Transformation Services (DTS) is one of your options, here is a good site
http://www.sqldts.com/
http://sqlservercode.blogspot.com/
"Vivek" wrote:

> Hi,
> We are using SQL server at Factory and HeadOffice and both are not
> linked,
> We want to send some data from HO to Factory's Sql server and vice
> versa through CD/Floppy.
> How to do this ?. (Export/Import) .
> Can be do this using programming?
> Please reply back
> Please also let me know good source for advance Level programming for
> SQL Server
> Thanks in advance
> Vivek Bharadwaj
>