Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1306
  • Last Modified:

How to export .dat file data to .txt files

Hi All
I have a database and all the files are in .dat format. How do I export them all to .txt format. Arethere any programs that can do that ?

Cheers
0
meperera
Asked:
meperera
1 Solution
 
peter57rCommented:
What database created these files- how were they created?

(.dat file extension can be anything - you might as well say 'i have some files' )
0
 
ayus80Commented:
Try right click at file and select open with.
use notepad to open that file
0
 
mepereraAuthor Commented:
they were created using ms sql
0
 
Mark WillsTopic AdvisorCommented:
Is that ms sql or my sql as per the zone... ".dat" as an MS SQL file doesn't make sense... Are they big ? can you zip and post one ?

if mysql : http://dev.mysql.com/doc/refman/5.0/en/select.html   and then do a ctrl+F to do a find for  outfile
e.g.  SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  FROM test_table;

if mssql : http://msdn.microsoft.com/en-us/library/ms162802.aspx

e.g. bcp "SELECT Name FROM AdventureWorks.Sales.Currency" queryout Currency.txt -T -c
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now