copying table in a database

Hi good day to everybody,

Can we copy a table from a database and saved it into a diskette? Because i did not find or maybe i miss or doesn't know how to do it from EXPORT/IMPORT tools. The computer to where I attach the table is not connected on d'same network, and if I backup & then reinstall the whole database into that PC, all records in their will be overwritten by the new one which is not I wanted to be.Hi,

did you try to use dts? or copy you database to a webserver? or just copy your db to xml or a acces db ?

this could be intresting to you:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21261328.html|||Thank you for the link, But i did not find the simpliest way to transfer a table from a database into a diskette and put it into another database in another computer not connected on the same network where i will take a table.

|||Hi,
IMO, there is no other simple way to copy a table. The last post was quite right. You'll have to convert it to a different format so that your destination computer could open it. A good format is access database (*.mdb) if your destination computer has access installed.

SQLServer stores its table,database,triggers,etc... information in a (*.mdf, *ldf) files usually found in C:\Program Files\Microsoft SQL Server\MSSQL\Data. But you can't copy it directly. You must stop the server first...

Contrast to that, if you want to copy the entire database, you could use the bacjup database and just restore it to the destination computer...
cheers,
Paul June A. Domag|||Thank you very much & have a nice day...|||

Paul Domag wrote:

You'll have to convert it to a different format so that your destination computer could open it. A good format is access database (*.mdb) if your destination computer has access installed.

and then how can I import the MDB table into the destination SQL server?|||Hi,
To import data from Access to SQL. You could use DTS (Data Transfer Service? not sure on the acronym). Its a wizard that migrates data from other sources to SQLServer...

cheers,
Paul June A. Domag