Friday, March 9, 2012

Quick question: Exporting data

Hi,

What data format can MS SQL Server 2000 export??

WingWing (wing328@.yahoo.com) writes:
> What data format can MS SQL Server 2000 export??

With BCP you can get many formats, either by use of simple command-
line options or a format file. By using DTS you can probably get a
few more. You can also get data in XML if you like.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

No comments:

Post a Comment