.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!
JklugAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike TomlinsonHigh School Computer Science, Computer Applications, and Mathematics TeachersCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.