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.

Answer 1

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

 

ChasAA

Answer 2

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'

 

Answer 3

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
_______

 

Answer 4

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

Answer 5

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