Change filed separator

  • Thread starter Thread starter Ronald
  • Start date Start date
R

Ronald

Hi Experts,

We work with an Access2000 (dutch version) application. One of the things
this application (VBA) does, is create an ascii-text file that can be merged
with Word. The file looks like "fld1" ; "fld2" ; 12345 ; "fld3" etc.
Default (in the netherlands) is that a semicolon is used as field separator.
When I open Access and ,anually try to export a table to a text-file, the
file that is created looks just the same. And that's good.
Now we also have a Win2K3 Terminal Server - English version; When I start
the application and try to make the merge-file, VBA comes with an error:
Error 3441: Text file specification filed separator marches decimal
separator or text delimiter.
When I check the regional settings on the Terminal Server, it's set to
"Dutch" and the separator is a semicolon. So it seems to me that VBA doesn't
use the regional settings but instead the default for the operating system.
When I manually open Access and try to export a table, the regional settings
will be used and I can create the delimited-text-file.
So, does anyone know how I can change a setting so VBA will use the regional
settings instead of the Regionals that the OS is using?

Please help me!

Ronald
 
Hi Ronald,

Have you tried using an export specification that includes the ";"
separator?
 
All,

I ran into the same error message as described below, but in a different
situation. I tried to import a CSV-separated file. "Not a big deal", but
Access proved me wrong.

To cut a long story short: when using the import wizard (File --> Get
External Data --> Import), check out the advanced settings. I had a ","
(comma) both as Field Delimiter and as Decimal Separator. Obiously, you're
likely to run into problems then. Changing the Decimal Separator to "." (dot)
or in fact any other symbol than "," made that I could import my file without
any more problem.

Hope this helps for other users.

Regards,

Mark.
 
Back
Top