Solved

Excel - upload from DAT file

Posted on 2011-03-16
3
236 Views
Last Modified: 2012-05-11
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
Comment
Question by:tahirih
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
anonxxxx2011 earned 500 total points
ID: 35149855
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
 

Author Comment

by:tahirih
ID: 35151102
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
 

Author Closing Comment

by:tahirih
ID: 35202228
Thank you.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Move data from one sheet to another 11 35
Excel Formula 5 45
VBA: copy range dynamically based on config sheet v2 3 34
Msgbox tickler 10 25
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

773 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