Cannot disable ExportCurrencySymbols in schema.ini file

[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

 

[John Nurick]

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

 

[Radu Stanciu]

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

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

 

[John Nurick]

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

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