sql server 7.0 .dat file

Results 1 to 2 of 2

Thread: sql server 7.0 .dat file

  1. #1
    Join Date
    Dec 1969

    Default sql server 7.0 .dat file

    Hi,<BR><BR>This is slightly away from ASP.<BR><BR>I&#039;ve submitted all my data to a table in SQL Server 7.0. Now I want to export this data to a .dat file.<BR><BR>I usually just use the DTS but in this case I must use a .dat file.<BR><BR>How do I create this. I have found very little inforamtion in other sites (more specific) and would be obliged for any help.<BR><BR>thanks

  2. #2
    Join Date
    Dec 1969

    Default DTS can do that!

    DTS can export table data to many common formats. On my system, using the DTS wizard, I selected my SQL7 Db as source and then in the destination I chose text file (the last option in the list). Then I had to specify the file to save it to, delimiter or fixed, and a few other options.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts