SQL 2005 export csv batch process

Asked By rosellas phillips 10 points N/A Posted on - 04/23/2013

Dear Friends,

I am using SQL 2005 and would like to export the address data in the database to csv. Please advice on how doing SQL 2005 export csv batch process. If you can provide me the script for that, It will be a great help.

Thanks in Advance,

Rosellas Phillips

• Status: Open
• Question Views: 1303
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: ActionScript

Best Answer by Copeland Hughley

Go To Solution

Answered By Bradford Senior 0 points N/A #165290

SQL 2005 export csv batch process

Hi!

You can use the bcp method by command line instructed by this link: Export SQL 2005 to csv.

Or by the Management Studio – using management studio in exporting to csv.

And there is a utility that you can put on your server and you can use the code and edit it depending on your needs.

Heres the link – Simplified import and export csv to sql and vice versa.

About Bradford Senior

Questions
3

Answers
7

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 05/01/2013
• Question Category: ActionScript

Answered By Butler Ogg 0 points N/A #165291

SQL 2005 export csv batch process

Hello,
There are four easy steps you should follow to make the desired process, dealing with SQL server 2005 is not difficult, The following link is the page that has the steps.

1- Downloading Invoke Sql Cmd2.ps1

2- Creating table disk space

3- Saving the SQL scripting code of table disk space

4- Using the script of table disk space which contains information about disk space and saving data in CSV file.

The next link has executing the above four steps in-details and screenshots follow them and problem will be solved successfully.

About Butler Ogg

Questions
2

Answers
21

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 05/05/2013
• Question Category: ActionScript

Best Answer

Best Answer

Answered By Copeland Hughley 15 points N/A #165292

SQL 2005 export csv batch process

Hello Rosellas,

Here are a few steps you can follow to solve your problem.

 SQL 2005, this is straightforward:

 1. Unfasten SQL Server organization studio and reproduce the SQL declaration you need into the TSQL, such seeing that exec Sp _whatever.

 2. Query-> Results to Grid.

3. Look at the SQL proclamation and run it.

 4. Highlight the information consequences (left-click on higher left region of results grid).

 5. Now right-click and choose to keep consequences as.

6. Select CSV in the 'put aside as' category, cross the threshold a file given name, select a place and click Save.

I take it you are looking at this along with curtisboy's suggestion, right? Good idea.

Thanks.

About Copeland Hughley

Questions
5

Answers
10

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 05/07/2013
• Question Category: ActionScript