Transfer Data from Table to TextFile

• rahulostwal

  Newbie

  Points: 1

  More actions

  November 27, 2012 at 6:51 am

  #265256

  how to transfer data from table to textfile with upto date range.

• Lowell

  SSC Guru

  Points: 323527

  More actions

  November 27, 2012 at 6:56 am

  #1562661

  bcp.exe is a command line utility for importing and exporting to text.

  it supports using a query, so you can construct a query that uses a WHERE clause that limits your data.

  if you have xp_cmdshell enabled, you could call it from TSQl as well, but remember it is a command line program

  bcp "SELECT object_name(object_id) As TbLName,name as ColName FROM SandBox.sys.columns WHERE create_date > DATEADD(dd, -30,GETDATE()) ORDER BY object_name(object_id), column_id" queryout C:\Data\Objects.txt -t"|" -c -T

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!