June 27, 2007 at 2:20 am
Hi,
I have an table with two columns Unit ID and Value which totally has 5876383 rows. Which is the best method to export this data either to xml or PDF in the shortest time..
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
June 27, 2007 at 3:13 am
Try using import/export wizard to export to xml. and i dont think so there is a direct possible methd to export to pdf. You can use reporting services to get your query results in pdf.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 27, 2007 at 4:56 am
Hi Sugesh,
My DB is SQL 2000 and in Import/Export i dont have any export to xml option...it has only excel,csv,access....Atleast xml is ok for me....Do i need to something else to get this xml option in export??
Regards,
Sakthi
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply