Post reply

Export Table to text

  • September 10, 2008 at 12:29 am

    #92481

    I have 2 tables and I need a csv file of the 2 joined together.

    I want also the csv file to include headers as well.

    I assume that I will build a select command to get the information and then export it to a csv file or text.

    If its easiest I can create a new table to insert all the informations I want and then export it.

    How do I export though??

  • September 10, 2008 at 12:44 am

    #869415

    You can export the data using Import Export Wizard and have the table joining query as source and export it to a csv file. Other option is to use BCP with query tag i think its -q.

  • September 11, 2008 at 4:28 am

    #870191

    thankss

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply