Prev: Differences between VBA in Excel 2007-2010
Next: #ref error
From: shapper on 18 May 2010 05:42
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
From: Helmut Meukel on 18 May 2010 14:58
"shapper" <mdmoura(a)gmail.com> schrieb im Newsbeitrag
news:9039d650-026e-4b02-abc6-38dead5bf155(a)j9g2000vbp.googlegroups.com...
> 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.

From: Tim Williams on 18 May 2010 22:09
Is the mime type a problem ? It should still open fine in your other
application.

Tim

"shapper" <mdmoura(a)gmail.com> wrote in message
news:9039d650-026e-4b02-abc6-38dead5bf155(a)j9g2000vbp.googlegroups.com...
> 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


 | 
Pages: 1
Prev: Differences between VBA in Excel 2007-2010
Next: #ref error