Solved

How to export .dat file data to .txt files

Posted on 2008-06-17
4
1,295 Views
Last Modified: 2008-07-11
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
Comment
Question by:meperera
4 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 21800811
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
 
LVL 2

Expert Comment

by:ayus80
ID: 21800873
Try right click at file and select open with.
use notepad to open that file
0
 

Author Comment

by:meperera
ID: 21800951
they were created using ms sql
0
 
LVL 51

Accepted Solution

by:
Mark Wills earned 500 total points
ID: 21805046
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read about achieving the basic levels of HRIS security in the workplace.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now