David, Most generic format you can get it out of SQL Server in is CSV by using a DTS ( Export Data ) wizard to text format. Another alternative is the bcp command line tool, which produces standardised formats These are documented in SQL Books Online ( free download from Microsoft ) http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Regards AJ "david luo" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > thanks in advance > > _____________________________________________________________ > Are you a Techie? Get Your Free Tech Email Address Now! Visit >http://www.TechEmail.com > > _____________________________________________________________ > Select your own custom email address for FREE! Get [EMAIL PROTECTED] w/No Ads, 6MB, >POP & more! http://www.everyone.net/selectmail?campaign=tag > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])