.csv format from ssms

Question

.csv format from ssms

Viewing 6 posts - 16 through 20 (of 20 total)

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

Scott D. Jacobson SSCertifiable Points: 6149 More actions · Answer 1

anthony.green (8/17/2012)
run query in ssms, results to grid, right click top left hand blank thing to select the whole result set including headers, then right click, save results as

But then he has the same problem. In fact, I think this is what he as doing originally when they told him it's not a "true" csv. It's not delimited. It's a fixed-width file. Or it's tab-delimited, I forget which.

In the Export Wizard, you need to choose Flat File as your destination.

Ant-Green SSC Guru Points: 113507 More actions · Answer 2

Scott D. Jacobson (8/17/2012)
anthony.green (8/17/2012)
run query in ssms, results to grid, right click top left hand blank thing to select the whole result set including headers, then right click, save results as
But then he has the same problem. In fact, I think this is what he as doing originally when they told him it's not a "true" csv. It's not delimited. It's a fixed-width file. Or it's tab-delimited, I forget which.
In the Export Wizard, you need to choose Flat File as your destination.

Import/Export wizard does like temp tables.

If you export to the query to file then you have to save it as a rpt file or add comma's in between each column to export in a csv fashion.

You can run query to grid, click the top left hand gray box, then you are given, copy, copy with headers etc, one option is to save results as, and it allows you to save as a CSV.

Scott D. Jacobson SSCertifiable Points: 6149 More actions · Answer 3

anthony.green (8/20/2012)
Scott D. Jacobson (8/17/2012)
anthony.green (8/17/2012)
run query in ssms, results to grid, right click top left hand blank thing to select the whole result set including headers, then right click, save results as
But then he has the same problem. In fact, I think this is what he as doing originally when they told him it's not a "true" csv. It's not delimited. It's a fixed-width file. Or it's tab-delimited, I forget which.
In the Export Wizard, you need to choose Flat File as your destination.
Import/Export wizard does like temp tables.
If you export to the query to file then you have to save it as a rpt file or add comma's in between each column to export in a csv fashion.
You can run query to grid, click the top left hand gray box, then you are given, copy, copy with headers etc, one option is to save results as, and it allows you to save as a CSV.

I'm not sure I follow you. "Results to file" in a query window does indeed output to a .rpt file. The other method you mentioned; clicking in the corner of the Results grid and highlighting everything then right-clicking and select Save Resutls As allows you to output a CSV.

The Wizard also allows you to save to CSV if you choose Flat File as your destination and Delimited. The wizard has the added benefit of being able to save the entire thing as SSIS for later use.

Ant-Green SSC Guru Points: 113507 More actions · Answer 4

Scott D. Jacobson (8/20/2012)
anthony.green (8/20/2012)
Scott D. Jacobson (8/17/2012)
anthony.green (8/17/2012)
run query in ssms, results to grid, right click top left hand blank thing to select the whole result set including headers, then right click, save results as
But then he has the same problem. In fact, I think this is what he as doing originally when they told him it's not a "true" csv. It's not delimited. It's a fixed-width file. Or it's tab-delimited, I forget which.
In the Export Wizard, you need to choose Flat File as your destination.
Import/Export wizard does like temp tables.
If you export to the query to file then you have to save it as a rpt file or add comma's in between each column to export in a csv fashion.
You can run query to grid, click the top left hand gray box, then you are given, copy, copy with headers etc, one option is to save results as, and it allows you to save as a CSV.
I'm not sure I follow you. "Results to file" in a query window does indeed output to a .rpt file. The other method you mentioned; clicking in the corner of the Results grid and highlighting everything then right-clicking and select Save Resutls As allows you to output a CSV.
The Wizard also allows you to save to CSV if you choose Flat File as your destination and Delimited. The wizard has the added benefit of being able to save the entire thing as SSIS for later use.

Running through the wizard using # temp tables results in invalid object errors, to the wizard will not suit the OP's requirements.

I have attached screenshots of how to to it via SSMS.

Scott D. Jacobson SSCertifiable Points: 6149 More actions · Answer 5

anthony.green (8/20/2012)
Scott D. Jacobson (8/20/2012)
anthony.green (8/20/2012)
Scott D. Jacobson (8/17/2012)
anthony.green (8/17/2012)
run query in ssms, results to grid, right click top left hand blank thing to select the whole result set including headers, then right click, save results as
But then he has the same problem. In fact, I think this is what he as doing originally when they told him it's not a "true" csv. It's not delimited. It's a fixed-width file. Or it's tab-delimited, I forget which.
In the Export Wizard, you need to choose Flat File as your destination.
Import/Export wizard does like temp tables.
If you export to the query to file then you have to save it as a rpt file or add comma's in between each column to export in a csv fashion.
You can run query to grid, click the top left hand gray box, then you are given, copy, copy with headers etc, one option is to save results as, and it allows you to save as a CSV.
I'm not sure I follow you. "Results to file" in a query window does indeed output to a .rpt file. The other method you mentioned; clicking in the corner of the Results grid and highlighting everything then right-clicking and select Save Resutls As allows you to output a CSV.
The Wizard also allows you to save to CSV if you choose Flat File as your destination and Delimited. The wizard has the added benefit of being able to save the entire thing as SSIS for later use.
Running through the wizard using # temp tables results in invalid object errors, to the wizard will not suit the OP's requirements.
I have attached screenshots of how to to it via SSMS.

Ah that's what I was missing. Should have gone back an re-read the query. Thanks for clearing that up Anthony.

surma.sql SSCommitted Points: 1552 More actions · Answer 6

anthony.green (8/17/2012)
run query in ssms, results to grid, right click top left hand blank thing to select the whole result set including headers, then right click, save results as

Thanks for Your Help

Problem solve

I run Query in SSMS, results to Text(set output format to comma Delimited in query option under Text). copy the results and save that results to .csv format and it works.