Export default Delimiter
in [General]
|
From: Bart Steur on 15 Feb 2005 06:17 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
From: Nikos Yannacopoulos on 15 Feb 2005 06:30 Bart, This default setting is coming from Windows regional settings (number settings), where the list separator character is specified. HTH, Nikos Bart Steur wrote: > 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 > >
From: Van T. Dinh on 15 Feb 2005 07:29 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. -- HTH Van T. Dinh MVP (Access) "Bart Steur" <solnews(a)xs4all.nl> wrote in message news:%23wB%23r$0EFHA.2156(a)TK2MSFTNGP10.phx.gbl... > 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 > >
From: Bart Steur on 15 Feb 2005 08:18 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 "Van T. Dinh" <VanThien.Dinh(a)discussions.microsoft.com> wrote in message news:%23sSj5k1EFHA.3384(a)tk2msftngp13.phx.gbl... > 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. > > -- > HTH > Van T. Dinh > MVP (Access) > > > "Bart Steur" <solnews(a)xs4all.nl> wrote in message > news:%23wB%23r$0EFHA.2156(a)TK2MSFTNGP10.phx.gbl... >> 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 >> >> > >
From: Nikos Yannacopoulos on 15 Feb 2005 08:39 Absolutely right! You got me there, I have no idea. Bart Steur wrote: > 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 > > > "Van T. Dinh" <VanThien.Dinh(a)discussions.microsoft.com> wrote in message > news:%23sSj5k1EFHA.3384(a)tk2msftngp13.phx.gbl... > >>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. >> >>-- >>HTH >>Van T. Dinh >>MVP (Access) >> >> >>"Bart Steur" <solnews(a)xs4all.nl> wrote in message >>news:%23wB%23r$0EFHA.2156(a)TK2MSFTNGP10.phx.gbl... >> >>>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 >>> >>> >> >> > >
|
Next
|
Last
Pages: 1 2 Prev: disabling Access 03 functions to make 97 database work Next: Library References |