• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

Excel - upload from DAT file

I have many files in DAT format. Is there  a way to change the DAT files to a Txt file that Excel with recognize without having to launch Excel, then open the file, then change into an Excel workbook?

I.e. is there a way to change formats from the Computer file screen? Right now I have to open Notepad, save as text, then Excel, save as Excel Wkbk, to take the file from Dat to Wkbk.

Thanks
0
tahirih
Asked:
tahirih
  • 2
1 Solution
 
anonxxxx2011Commented:
Isn't a Dat file just a delimited data file? You should be able to open that directly with excel - no need for notepad at all.
0
 
tahirihAuthor Commented:
Yes, you are correct. This is a step I do for validation.

Is there a way to change the form from dat to xls without launching (i.e. automate the delimiter definitions). I have many many files, and this process takes time.

Thanks
0
 
tahirihAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

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