question

MEL MILLER avatar image
MEL MILLER asked

Export text file in ASCII format

I need to export a text file in the ASCII format. How is this done? I have MS SQL SERVER 2005

best-practiceetlexport-data
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Steve Jones - Editor avatar image
Steve Jones - Editor answered

bcp will allow you to pull data out of a SQL Server. You can read about how it works here: http://msdn.microsoft.com/en-us/library/ms162802%28SQL.90%29.aspx

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.