Export default Delimiter

[Bart Steur]

Hello,

I'm using the following command in a function:

DoCmd.TransferText A_EXPORTDELIM, "", MyTable, MyExportFile

As you can see I'm not using an export specification. This results in using
the default settings.

I'm using this function on two PC's (both running XP Pro with Access 2000).
But on one it exports with a comma (,) as delimiter and on the other it
exports with a semicolon ( as delimiter.

I want both computers to export with a comma (,). Where can I change this
default setting.

Thanks in advance.

B. Steur

 

[Nikos Yannacopoulos]

Bart,

This default setting is coming from Windows regional settings (number
settings), where the list separator character is specified.

HTH,
Nikos

 

[Van T. Dinh]

Probably, you have different Regional Settings on the 2 PCs and the 2
Settings have different "List Separators".

Check the Regional Settings / List Separators on the 2 PCs.

 

[Bart Steur]

I've done that, but is doesn't work for the doCmd.transfertext function. It
does work when you export the table directly by selecting Export... from the
popup menu.

My regional settings have a List Separator set to "="
I've created a table (Table1) with 5 columns (Any data type will do). It
contains three rows.
I've created a from with a button. In the OnClick event of that button I've
set the following command:

DoCmd.TransferText acExportDelim, , "Table1", "C:\TABLE1.TXT"

Table1.txt contains, after pressing the button, three comma separated data
records and not "=" separated data.

Maybe you can try this/recreate is.

Thanks,

Bart

 

[Nikos Yannacopoulos]

Absolutely right! You got me there, I have no idea.

 

[John Nurick]

I'm using the following command in a function:

DoCmd.TransferText A_EXPORTDELIM, "", MyTable, MyExportFile

As you can see I'm not using an export specification. This results in using
the default settings.

I'm using this function on two PC's (both running XP Pro with Access 2000).
But on one it exports with a comma (,) as delimiter and on the other it
exports with a semicolon ( as delimiter.

I want both computers to export with a comma (,). Where can I change this
default setting.

Hi all,

Having read the rest of the thread I suspect there's a difference in
registry settings between the two machines. Take a look at (probably)

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text

and check the values for "Format". I'm guessing that on one machine it
is "CSVDelimited", while on the other it's "DELIMITED(". You may need
to search the registry for other likely places.

For documentation, start with the Help topic "Initializing the Text Data
Source Driver".