Groups > comp.databases.ms-sqlserver > #1150

Re: MSSMSE - Export results to CSV

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: MSSMSE - Export results to CSV
Date	2012-06-22 11:33 +0200
Organization	Erland Sommarskog
Message-ID	<XnsA07A7596B3550Yazorman@127.0.0.1> (permalink)
References	<5oudnZwNaMRT-37SnZ2dnUVZ8g-dnZ2d@bt.com> <XnsA079F0DCCBB92Yazorman@127.0.0.1> <FpednYO2bofgOn7SnZ2dnUVZ8kydnZ2d@bt.com>

Show all headers | View raw

Cathy (Cathy@Nospam.com) writes:
> I was just looking at BCP, struggled a bit, got most of it working in the 
> end, but still not quite the same format.

So what was wrong with the 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 
 
I don't know about MySQL, but SSMS is just a client tool for interactive
queries. 

There is also the Export/Import wizard which you find the program 
group for SQL Server.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

MSSMSE - Export results to CSV "Cathy" <Cathy@Nospam.com> - 2012-06-21 19:24 +0100
  Re: MSSMSE - Export results to CSV Erland Sommarskog <esquel@sommarskog.se> - 2012-06-21 23:40 +0200
    Re: MSSMSE - Export results to CSV "Cathy" <Cathy@Nospam.com> - 2012-06-22 00:00 +0100
      Re: MSSMSE - Export results to CSV Erland Sommarskog <esquel@sommarskog.se> - 2012-06-22 11:33 +0200
        Re: MSSMSE - Export results to CSV "Cathy" <Cathy@Nospam.com> - 2012-06-22 18:48 +0100
          Re: MSSMSE - Export results to CSV Erland Sommarskog <esquel@sommarskog.se> - 2012-06-22 20:38 +0200
            Re: MSSMSE - Export results to CSV "Cathy" <Cathy@Nospam.com> - 2012-06-22 22:45 +0100
              Re: MSSMSE - Export results to CSV Erland Sommarskog <esquel@sommarskog.se> - 2012-06-23 11:28 +0200
                Re: MSSMSE - Export results to CSV "Cathy" <Cathy@Nospam.com> - 2012-06-23 23:49 +0100

csiph-web