[Webinar] Streamline your web hosting managementRegister Today

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

.dat Files

I need to somehow open a .dat file and have the data move to a database (probably access). I can not find any program that can open it so I can even view the data. Is there a viewer that will open it (notepad won't open it cleanly) and can I somehow use the .dat file to run a SQL query or do I need to simply open the file and read it in one word at a time?

Thanks for any help I need to be able to at least open the file to view it and pull the info out!
0
Jklug
Asked:
Jklug
3 Solutions
 
Mike TomlinsonMiddle School Assistant TeacherCommented:
Do you know what program originally created the .dat file?  The .dat extension does not actually indicate any specific internal format.
0
 
jessy_houleCommented:
Two different options...

1) Import the .DAT file into Access (with either fixed or delimited), and then you can run SQL statements off of the newly created table.

OR

2) Link the .DAT file (with either fixed or delimited), and then you can run SQL statements off of the newly linked table.
0
 
pg_indiaCommented:
well a dat file is basically a file which stores the data depending on the program which is acess ig it. If you think that dat file refer to the movie file you are wrong. I can create a dat file and use it as a word file..

Just rename and .doc file to .dat file and then right click and open it with word and it will open...because the extension is not important what is important is the format in whcih way the data is stored.

Just tell is the dat file you have created or some other program has created it...??

0
 
JklugAuthor Commented:
some unknown program made it. My clients client (follow that logic) created it and dumped it off without any means to read it. They did attach a nice message about how their IT department had to create a program to make it readable. WOOHOO PUZZLES!!! Since their IT department is too busy I may get the job. I did download WordPerfect which seems to read it but after 30 days I can't use that anymore.


EDIT DUH notepad didnt work so I assumed wordpad wouldnt either.... it did sorry:) I'll split the points somehow
0
 
pg_indiaCommented:
Maybe it is a word perfect format file..)))))

then we have a way out....what u all experts say...

http://www.softinterface.com/Convert-Doc/Convert-Doc-WPD-Target.htm
http://www.carleton.ca/CCS/docs/word_excel_docs/wordperfect.html

jus a suggestion...you can goto this link and download. this will convert it to doc files...


0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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