Export to Excel As A DUMP

[nikhilparchure]

The problem I am facing is exporting in EXCEL,
I use DB Artisan which saves in EXCEL upto some 16 thousand records .

What I want is and ISQL comand that will export a physical or a temporary table to a physical location as an excel file ,,,,,,

Regards
Nikhil Parchure

 

[markmar1]

If you just need a comma delimited file to upload into Excel, why not just use the bcp utility??? Done this many time using different delimiters with no problems. As long as the number of rows you are extracting does not exceed Excel limitations.