You are currently viewing How to Export SQL Table Data To A Text File

How to Export SQL Table Data To A Text File

How to Export SQL Table Data To A Text File

To export SQL Server table data to a text file, we will use NORTHWIND Database and SQL Server Management Studio 2014.

Step-I: Open SQL Server Management Studio and Click on Connect button to connect to SQL Server instance.

Step-II: Expand Databases, right-click on NORTHWIND database(for this demo), move cursor to Tasks and then Export Data on the pop-up window as shown below.

Step-III: SQL Server Import and Export Wizard will open, Click on Next button.

Step-IV:

  • Choose Data Source as SQL Server Native Client 11.0
  • Select Server Name.
  • To select Authentication, Either Select Use Windows Authentication or Use SQL Server Authentication radio button.
  • Select Source Database from where you want to export table data.
  • Click on Next button.

Step-V: 

  • Select Flat File Destination to export in Text File.
  • Browse File name.
  • Format should be Delimited.
  • Check the checkbox Column names in the first row.
  • Click on Next button.

Step-VI: Choose Copy data from one or more tables or views or Write a query to specify the data to transfer.

Click on Next button.

Step-VII: If you check Write a query to specify the data to transfer radio button, then a new window will open where you write a query and click on Parse button to check the validity of query and click on Next button.

Step-VIII: 

  • Select Source table from drop down.
  • {CR}{LF} Row delimiter as shown in below image.
  • Comma(,) as Comma delimiter.
  • Click on Preview  button if you want to preview the result.
  • Click on Next button.

Step-IX: Check the Run Immediately check box and Click on Next button.

Step-X: Click on Finish button.

Step-XI: Process will be executed and completed successfully as shown in the following image, with the rows inserted.

Step-XII:

  • Click on Close button to close SQL Server Import and Export Wizard.
  • Check your text file where you exported data.

Leave a Reply