Export table from database to csv file

by

Some ideas:

From SQL Server Management Studio

 1. Run a SELECT statement to filter your data
 2. Click on the top-left corner to select all rows
 3. Right-click to copy all the selected
 4. Paste the copied content on Microsoft Excel
 5. Save as CSV

Using SQLCMD (Command Prompt)

Example:

From the command prompt, you can run the query and export it to a file:

sqlcmd -S . -d DatabaseName -E -s, -W -Q "SELECT * FROM TableName" > C:\Test.csv

Do not quote separator use just -s, and not quotes -s’,’ unless you want to set quote as separator.

More information here: ExcelSQLServer

Notes:

  • This approach will have the “Rows affected” information in the bottom of the file, but you can get rid of this by using the “SET NOCOUNT ON” in the query itself.

  • You may run a stored procedure instead of the actual query (e.g. “EXEC Database.dbo.StoredProcedure”)

  • You can use any programming language or even a batch file to automate this

Using BCP (Command Prompt)

Example:

bcp "SELECT * FROM Database.dbo.Table" queryout C:\Test.csv -c -t',' -T -S .\SQLEXPRESS

It is important to quote the comma separator as -t’,’ vs just -t,

More information here: bcp Utility

Notes:

  • As per when using SQLCMD, you can run stored procedures instead of the actual queries
  • You can use any programming language or a batch file to automate this

Hope this helps.

More Related Contents:

  1. Countdown in javascript, database and php
  2. Can we protect against SQL-injection by writing Javascript code correctly? how? [closed]
  3. Example JavaScript code to parse CSV data
  4. How to export JavaScript array info to csv (on client side)?
  5. How to connect to SQL Server database from JavaScript in the browser?
  6. Is there a built in way to convert a comma-separated string to an array?
  7. What is this JavaScript “require”?
  8. Mongoose and multiple database in single node.js project
  9. How to convert JSON to CSV format and store in a variable
  10. Leaderboard ranking with Firebase
  11. How can I parse CSV data with JavaScript?
  12. Export to csv in jQuery
  13. Is it possible to access an SQLite database from JavaScript?
  14. How to convert CSV to JSON in Node.js
  15. download csv file from web api in angular js
  16. Converting JSON object to CSV format in JavaScript
  17. Importing data from multiple csv files in D3
  18. How to convert image to byte array using javascript only to store image on sql server?
  19. JavaScript array to CSV
  20. Using javascript to download file as a.csv file
  21. How to parse CSV data?
  22. Javascript to csv export encoding issue
  23. What MySQL drivers are available for node.js? [closed]
  24. How do I stream response in express?
  25. What is the best way to store private data in react-native?
  26. Javascript: Splitting a string by comma but ignoring commas in quotes
  27. What is the difference between id and _id in mongoose?
  28. How can I read a local file with Papa Parse?
  29. How to return only value of a field in mongodb
  30. read csv/tsv with no header line in D3

Leave a Comment