Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Microsoft ISV Community Center Forums >> Visual Basic for Applications (VBA)

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.

[134 byte] By [Kishorepbp] at [2007-12-23]
«« Exporting a Datagrid to Excel
»» Gadgets in Windows Live Space?
# 1

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

ChasAA

ChasAA at 2007-8-30 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
# 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'

HiMom at 2007-8-30 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
# 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
_

JonPeltier at 2007-8-30 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
# 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

DavidAlexander at 2007-8-30 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
Microsoft ISV Community Center Forums
Visual Basic for Applications (VBA)

Microsoft ISV Community Center Forums Hot Topic

Microsoft ISV Community Center Forums New Topic

Microsoft ISV Community Center Forums

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified