none
How to convert excel file to .DAT file?

    Question

  • Hi

    I need urgently in my job to converfile to .DAT file?

     

    Can some one help on the same.

     

    Thanks

    Kishore.

    Friday, July 21, 2006 4:43 PM

All replies

  • Please elaborate on the .DAT file, ie format, which application will use it etc

     

    ChasAA

    Wednesday, July 26, 2006 9:07 AM
  • Here here...I need to do the same thing.  I have Excel files I've saved as .csv delimited files.  The files are pipe-delimited but I don't have a pipe-delimit extension. 

    I need to get these files saved with .dat extension.  I am copying them to an FPT location where another person is grabbing. them.  They need data files with .dat extensions.  I believe their scripts looks for these automatically.

    I have not found yet a method to convert .xls to .dat.

     

    Thanks!

     

    EW'

     

    Monday, July 31, 2006 8:18 PM
  • Nothing magic about pipe-delimited format. It's text, with entries separated by a pipe (vertical line character) within a record, and by carriage returns between records. Here's a nice explanation of the process, with some code examples:
    http://www.mcgimpsey.com/excel/textfiles.html

    There are a few utilities that will save a worksheet as pipe-delimited:
    http://www.smokeylake.com/excel/text_write_program.htm

    To find things like this, you can use Google. "Excel export pipe delimited".

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Tutorials and Custom Solutions
    http://PeltierTech.com
    _______

     

    Tuesday, August 01, 2006 3:29 AM
  • I've just had the exact same problem and Googled an answer.
    You cannot configure Excel but have to configure Windows.

    Do
        "Start -> Settings -> Control Panel -> Regional Settings."
            or
        "Start -> Settings -> Control Panel -> Regional and Language Options."

    Click "Customize" then change "List Separator" to the pipe character.

    In excel select "File -> Save As" and choose CSV.

    The registry key for this is
    HKEY_CURRENT_USER\Control Panel\International --> sList
    Friday, August 11, 2006 9:48 AM
  • Kishore

    Save your excel file as a .txt file.  U may get some error messages-ignore them. Rename the extension .txt to .dat  This again may give you a few error messages-ignore them.

    If you open the .dat file you will see all the coordinates you had in the excel spreadsheet.

    In Unigraphics to create a spline import the .dat file.

    I hope this helps.

    Joyee

     

     

    Friday, October 31, 2008 7:07 PM