Export from SQL Server table to Excel

Author Message
naveenjv

  • Total Posts : 1
  • Scores: 0
  • Reward points : 100
  • Joined: 7/31/2012
  • Status: offline
Export from SQL Server table to Excel Tuesday, July 31, 2012 6:16 AM (permalink)
0
Hi Experts,
I am a novice to poweshell. I would like to know how to export the content of a table present in a remote SQL Server table to an excel.
I would like to format first column of the table to text, second with number(8,2) after exporting to excel.
Thanks in advance.
Regards,
Naveen J V
 
#1
    Online Bookmarks Sharing: Share/Bookmark

    Jump to:

    Current active users

    There are 0 members and 2 guests.

    Icon Legend and Permission

    • New Messages
    • No New Messages
    • Hot Topic w/ New Messages
    • Hot Topic w/o New Messages
    • Locked w/ New Messages
    • Locked w/o New Messages
    • Read Message
    • Post New Thread
    • Reply to message
    • Post New Poll
    • Submit Vote
    • Post reward post
    • Delete my own posts
    • Delete my own threads
    • Rate post

    2000-2013 ASPPlayground.NET Forum Version 3.9