Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default Get Standard CSV File

Hello,

I am trying to save some data from Excel to a CSV file to import into
an application I am working on.
The problem is that I get a file with Mime:

application/vnd.ms-excel

Instead of:
text/csv

How can I create a standard text/csv file?

Thank You,
Miguel
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 49
Default Get Standard CSV File

"shapper" schrieb im Newsbeitrag
...
Hello,

I am trying to save some data from Excel to a CSV file to import into
an application I am working on.


Do you mean, you are programming this app?
Or is it an existing app and you are just working with this app?
If it's the first case, then which programming language are you using?
You could probably use DAO to read the excel file directly or
automate Excel to get the data from the excel file without first
exporting to a CSV file.

The problem is that I get a file with Mime:

application/vnd.ms-excel

Instead of:
text/csv

How can I create a standard text/csv file?

Thank You,
Miguel


How do you save the file?
Manually, selecting File, Save as ... from the menu
or by code? If the latter, provide your code, so we can look at it.

BTW, you _do_ know that the CSV standard isn't a standard
at all?
Depending on the localized version of Excel you are using, the
default format Excel is using by creating a CSV file or expecting
when reading a CSV file may be comma separated (in the US,
UK, ...) or semicolon separated (in Germany, France, ...)

Helmut.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 298
Default Get Standard CSV File

Is the mime type a problem ? It should still open fine in your other
application.

Tim

"shapper" wrote in message
...
Hello,

I am trying to save some data from Excel to a CSV file to import into
an application I am working on.
The problem is that I get a file with Mime:

application/vnd.ms-excel

Instead of:
text/csv

How can I create a standard text/csv file?

Thank You,
Miguel



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
standard deviation [email protected] Charts and Charting in Excel 3 April 16th 08 01:04 AM
standard deviation Ina Excel Discussion (Misc queries) 2 August 23rd 07 03:06 PM
Standard Colors steven Excel Worksheet Functions 3 October 21st 06 08:06 PM
Inserting a standard row through VBA [email protected] Excel Programming 2 July 26th 06 09:15 PM
File size problem: standard remedies not working. [email protected] Excel Programming 2 December 31st 03 08:10 PM


All times are GMT +1. The time now is 06:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"