Cannot disable ExportCurrencySymbols in schema.ini file

  • Thread starter Thread starter Radu Stanciu
  • Start date Start date
R

Radu Stanciu

Hi all,

I am exporting a table to a csv file and thus I'm creating a schema.ini
file to make sure all the parameters are set they way I want them to.
However, I'm having problems setting ExportCurrencySymbols to No.

In the Access help files and documentation I found on the Internet, the
value is always ExportCurrencySymbols=Yes. I've tried setting it to No,
False and everything I could thought of that says a big "no", but no
luck. Has anyone tried this and got it to work? The rest of the
schema.ini file is ok, or at least I don't get any errors... I pasted it
below.

[da.txt]
CharacterSet=ANSI
TextDelimiter=none
ColNameHeader=True
DecimalSymbol=.
ExportCurrencySymbols=No
Format=TabDelimited

Thanks,

Radu Stanciu
 
Hi Radu,

I've never encountered ExportCurrencySymbols in a schema.ini. Every
reference I found in a quick Google search suggests, as does the Help
article "Initializing the Text Data Source Driver" that:

* It's the name of a registry setting and not a schema.ini setting.
* Even though there are some mentions of
ExportCurrencySymbols=Yes
the key actually takes a binary value of 00 or 01, not a string or
boolean.

For instance, in the computer at which I'm writing this,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text has
ExportCurrencySymbols as type REG_BINARY and value 01. There are similar
entries for other versions of Jet.





Hi all,

I am exporting a table to a csv file and thus I'm creating a schema.ini
file to make sure all the parameters are set they way I want them to.
However, I'm having problems setting ExportCurrencySymbols to No.

In the Access help files and documentation I found on the Internet, the
value is always ExportCurrencySymbols=Yes. I've tried setting it to No,
False and everything I could thought of that says a big "no", but no
luck. Has anyone tried this and got it to work? The rest of the
schema.ini file is ok, or at least I don't get any errors... I pasted it
below.

[da.txt]
CharacterSet=ANSI
TextDelimiter=none
ColNameHeader=True
DecimalSymbol=.
ExportCurrencySymbols=No
Format=TabDelimited

Thanks,

Radu Stanciu
Click to expand...
 
Ok, so... how do I disable this setting? :) I just want to have the
currencies in a numerical format, not with the associated currency
symbol. And I wouldn't like to mess with the Jet registry settings,
since they are system-wide settings and it's not really a good practice
to change them by code.

Does anyone have a schema.ini file that has this flag disabled?

Thanks,

Radu

John said:
Hi Radu,

I've never encountered ExportCurrencySymbols in a schema.ini. Every
reference I found in a quick Google search suggests, as does the Help
article "Initializing the Text Data Source Driver" that:

* It's the name of a registry setting and not a schema.ini setting.
* Even though there are some mentions of
ExportCurrencySymbols=Yes
the key actually takes a binary value of 00 or 01, not a string or
boolean.

For instance, in the computer at which I'm writing this,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text has
ExportCurrencySymbols as type REG_BINARY and value 01. There are similar
entries for other versions of Jet.





Hi all,

I am exporting a table to a csv file and thus I'm creating a schema.ini
file to make sure all the parameters are set they way I want them to.
However, I'm having problems setting ExportCurrencySymbols to No.

In the Access help files and documentation I found on the Internet, the
value is always ExportCurrencySymbols=Yes. I've tried setting it to No,
False and everything I could thought of that says a big "no", but no
luck. Has anyone tried this and got it to work? The rest of the
schema.ini file is ok, or at least I don't get any errors... I pasted it
below.

[da.txt]
CharacterSet=ANSI
TextDelimiter=none
ColNameHeader=True
DecimalSymbol=.
ExportCurrencySymbols=No
Format=TabDelimited

Thanks,

Radu Stanciu
Click to expand...
Click to expand...
 
It should be fairly safe if you alter the registry setting immediately
before exporting and restore it immediately afterwards.

Otherwise, you could use a type conversion function in the query you're
exporting.

Ok, so... how do I disable this setting? :) I just want to have the
currencies in a numerical format, not with the associated currency
symbol. And I wouldn't like to mess with the Jet registry settings,
since they are system-wide settings and it's not really a good practice
to change them by code.

Does anyone have a schema.ini file that has this flag disabled?

Thanks,

Radu

John said:
Hi Radu,

I've never encountered ExportCurrencySymbols in a schema.ini. Every
reference I found in a quick Google search suggests, as does the Help
article "Initializing the Text Data Source Driver" that:

* It's the name of a registry setting and not a schema.ini setting.
* Even though there are some mentions of
ExportCurrencySymbols=Yes
the key actually takes a binary value of 00 or 01, not a string or
boolean.

For instance, in the computer at which I'm writing this,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text has
ExportCurrencySymbols as type REG_BINARY and value 01. There are similar
entries for other versions of Jet.





Hi all,

I am exporting a table to a csv file and thus I'm creating a schema.ini
file to make sure all the parameters are set they way I want them to.
However, I'm having problems setting ExportCurrencySymbols to No.

In the Access help files and documentation I found on the Internet, the
value is always ExportCurrencySymbols=Yes. I've tried setting it to No,
False and everything I could thought of that says a big "no", but no
luck. Has anyone tried this and got it to work? The rest of the
schema.ini file is ok, or at least I don't get any errors... I pasted it
below.

[da.txt]
CharacterSet=ANSI
TextDelimiter=none
ColNameHeader=True
DecimalSymbol=.
ExportCurrencySymbols=No
Format=TabDelimited

Thanks,

Radu Stanciu
Click to expand...
Click to expand...
Click to expand...
 
Back
Top