Path: csiph.com!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!border3.nntp.ams.giganews.com!Xl.tags.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!local2.nntp.ams.giganews.com!nntp.bt.com!news.bt.com.POSTED!not-for-mail
NNTP-Posting-Date: Thu, 21 Jun 2012 18:00:13 -0500
From: "Cathy" <Cathy@Nospam.com>
Newsgroups: comp.databases.ms-sqlserver
References: <5oudnZwNaMRT-37SnZ2dnUVZ8g-dnZ2d@bt.com> <XnsA079F0DCCBB92Yazorman@127.0.0.1>
In-Reply-To: <XnsA079F0DCCBB92Yazorman@127.0.0.1>
Subject: Re: MSSMSE - Export results to CSV
Date: Fri, 22 Jun 2012 00:00:03 +0100
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="Windows-1252"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463
Message-ID: <FpednYO2bofgOn7SnZ2dnUVZ8kydnZ2d@bt.com>
Lines: 10
X-Usenet-Provider: http://www.giganews.com
X-AuthenticatedUsername: NoAuthUser
X-Trace: sv3-o8p9s9z7t5i45Icxr9dyBDTyI7lipJurb7C0kXqiBC6P/AjcN9FI4iVAfGigTNU7PlFGvjc+Gz3Yzi+!M5TLQ3L3M39On4+34Smu6BnXt6BdA3Vc10BLgGQg4fIFhi0QG6lmVY/W/6aRLcw81zbtwFb1Rgo=
X-Complaints-To: abuse@btinternet.com
X-DMCA-Complaints-To: abuse@btinternet.com
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 1617
Xref: csiph.com comp.databases.ms-sqlserver:1146

I was just looking at BCP, struggled a bit, got most of it working in the 
end, but still not quite the same format.

I was in fact hoping there was a way I could specify outfile as can be done 
in MySQL but I dont seem to get this option in MSSMSE

WIll keep looking, there must be a way

C