Hi People.
I have a .dat extension file which was produced by an accounting software. I need to have this file converted into an excel file.
Can anyone suggest any option.
I tried to save the file rename it .txt file and open it in excel but does not look good.
I also tried to save the file then open excel and delimit the file but still does not work both the options it gives me funny figures that i cannot understand.
Thanks in advance for your help.
muheebrahman,
On a blank screen click file/open
select all files (*.*)
open up the required document
Depending on the files content Excel may or may not be able to open it!
muheebrahman,
On a blank screen click file/open
select all files (*.*)
open up the required document
Depending on the files content Excel may or may not be able to open it!
Hi Peperammi69,
I have already tried to do this.. please see my post above point 2. it opens but in different characters..
muheebrahman,
I download a 100mb file daily from a website which contents 46 files, when I unzip, they are all .dat files. I then upzip to a folder, there I have created a ms-dos batch file which contents this one line
Double click the batch file and it will rename your files from .dat to .txt.HTML Code:
Open excel and selcet a file but select text files, select the file and the delimited window should open. Decide how the text is separated aeither space, comma or vertical line and follow the steps under option delimited.
Your file should be readable.
==========
Bigroo1958
Austin, Texas
==========
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks