How to convert excel file to .DAT file?

Hot Topic

Word 2003 Includetext XPath
iexplore.exe - Application Error
Can you use VBA to access a spread sheet embedded in a word doc?
AutoExec will not execute properly
How to track changes
Deleting Macro
VBA Excell Autofilter
messageBox not showing in current window
Applying one cell's formatting to another cell
A simple list of words from a word document

Microsoft ISV

Running a macro if new mail if from a specific address
Creating MROUND function
Order By DateDiff() in Access Report
Hyperlink in text (or anywhere). Use a LinkLabel >>
How to connect two locations to better communication?
upsized to SQL
installling business scorecard manager 2005
Passing on a value on an existing Access Report
opc
Control Break Trap will not work whilst Userform is displayed

How to convert excel file to .DAT file?

Hi

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

Can some one help on the same.

Thanks

Kishore.




Answer this question

How to convert excel file to .DAT file?

  • bulad

    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

  • dreameR.78

    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'

  • James_Steven

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

    ChasAA

  • Davids Learning

    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
    _______



  • How to convert excel file to .DAT file?
Answer this question