Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I need to export a sql server table in csv, but not all filed biut for example:
    filed1,filed5,field9...
    How to?

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,170
    Thanks
    47
    Thanked 980 Times in 910 Posts
    SQL Manager in the server or from a PC. You can then choose the fields you require.
    Copy the output into Excel and save as CSV.

    cheers, Paul

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by P T View Post
    SQL Manager in the server or from a PC. You can then choose the fields you require.
    Copy the output into Excel and save as CSV.

    cheers, Paul
    no SQL Manager only code vb6 or vba for excel

  4. #4
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,170
    Thanks
    47
    Thanked 980 Times in 910 Posts
    There are plenty of code examples on the web.

    cheers, Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •