Export data - default delimiter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

While exporting data from a table to a txt file using a macro (‘transfer
text’ with ‘Export delimited’ option) I’m getting the data delimited by
‘semicolon’ instead of with ‘comma’. This gives me error while importing data
in another computer. I had to change the delimiter to ‘comma’ using a text
editor for importing. How do I change the default delimiter to ‘Comma’ in the
exporting computer? I’m using MS Access 2002.

Thanking you in advance.
Gopi
 
Hi Gopi,

The default delimiter comes from the Windows regional settings (in the
Control Panel). Most European locales (except the British Isles) use ;
as the default delimiter, so that may be the issue if it's a continental
machine.

It may be possible to change the default used by Access without changing
the whole system, by making registry settings (see e.g.
http://office.microsoft.com/en-us/assistance/HP010321661033.aspx ),
though I've never investigated the detailed implications.

Otherwise, you can set up an import specification on your machine that
uses ; as the delimiter, and use that to import these files in future.
(start importing the file manually, and click the Advanced button in the
text import wizard; this lets you create and save an import
specification).
 
Back
Top