Export data to another Database

Hi,
There was some problem with a database in our SQL server 2000. So I was
trying to export the data from that database into an acces database and send
it to some one. But the problem is that we dont have Microsoft Office
installed on our data server. So i was wondering is there any other way of
having all that data in some other format so that it can be sent?
--
pmudHi,
Use DTS (coming along with sql server) and export the data into text file.
Thanks
hari
SQL Server MVP
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:5C4D7363-5D46-4A30-BEC8-F124726D841D@.microsoft.com...
> Hi,
> There was some problem with a database in our SQL server 2000. So I was
> trying to export the data from that database into an acces database and
> send
> it to some one. But the problem is that we dont have Microsoft Office
> installed on our data server. So i was wondering is there any other way of
> having all that data in some other format so that it can be sent?
> --
> pmud|||YOu could store it in a propetary format like csv, or bcp that out to a
binary format if you want to import the databack in another SQL Server base.
Another thing, if there is a SQL Server in the ither side would be to export
the data to another SQL Server database (perhaps an empty one) and backup
this as a whole.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"pmud" <pmud@.discussions.microsoft.com> schrieb im Newsbeitrag
news:5C4D7363-5D46-4A30-BEC8-F124726D841D@.microsoft.com...
> Hi,
> There was some problem with a database in our SQL server 2000. So I was
> trying to export the data from that database into an acces database and
> send
> it to some one. But the problem is that we dont have Microsoft Office
> installed on our data server. So i was wondering is there any other way of
> having all that data in some other format so that it can be sent?
> --
> pmud|||Hi
Even if you donot have Office installed on the system, you can use DTS to
export the data into MS Access format.
Just check about DTS in b ooks online.
Alternatively, The best way to export the data is in an XML format.
you can check the SELECT with FOR XML clause.
in the receiving end, you can use OPENXML
I believe this answers your question
--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"pmud" wrote:
> Hi,
> There was some problem with a database in our SQL server 2000. So I was
> trying to export the data from that database into an acces database and send
> it to some one. But the problem is that we dont have Microsoft Office
> installed on our data server. So i was wondering is there any other way of
> having all that data in some other format so that it can be sent?
> --
> pmud