Results 1 to 2 of 2

Thread: .DAT files (XP)

  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    .DAT files (XP)

    Someone just asked me if there's a way to open and convert a .dat file to Excel. I don't have a file to test, so I was wondering if anyone has had to do this? I'm thinking I'll have to parse the columns, but I'm not sure until I see a file

    This is something that is going to be done quite often, since they are taking readings from machinery in the factory and need to continually analyze it.

    Thanks!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: .DAT files (XP)

    What is the format of the DAT file? Many times these are just plain text files that excel can open directly and then be saved.
    In the file open, just select "all files" and then you can select the DAT file.

    If it can not be read directly, you can try the program that creates the DAT file and see if you can export into an excel or an ASCII (comma delimited, tab delimited, etc) text file.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •