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.
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:
There are a few utilities that will save a worksheet as pipe-delimited:
To find things like this, you can use Google. "Excel export pipe delimited".
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
I've just had the exact same problem and Googled an answer.
You cannot configure Excel but have to configure Windows.
"Start -> Settings -> Control Panel -> Regional Settings."
"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
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.