Transfer Text Error

D

David

I have a macro that uses the transfer text method to
export a table to a delimited text file.

On my pc, it works fine. When my guy out in France uses
it. The text file seems to be overwriting some lines so
it looks like two lines written over each other.

Please help
 
J

John Nurick

Hi David,

At a guess this is because of the different default field separators in
France (and most continental countries) and the UK.

Here, the separator (delimiter) is usually a comma. There, the comma is
used for the decimal point so is not available as a field separator, and
the semicolon is used instead.

It could be that your software is exporting a comma-delimited file which
is confusing the French software. One way round the problem might be to
export it as tab-delimited instead.
 
D

David

Hello John,

I'm sorry about not being clear. The transfer text method
in the macro is using a specification that uses ¶ as the
delimiter. This has worked fine in the past. Just
recently the French team has encountered this problem.
-----Original Message-----
Hi David,

At a guess this is because of the different default field separators in
France (and most continental countries) and the UK.

Here, the separator (delimiter) is usually a comma. There, the comma is
used for the decimal point so is not available as a field separator, and
the semicolon is used instead.

It could be that your software is exporting a comma- delimited file which
is confusing the French software. One way round the problem might be to
export it as tab-delimited instead.


I have a macro that uses the transfer text method to
export a table to a delimited text file.

On my pc, it works fine. When my guy out in France uses
it. The text file seems to be overwriting some lines so
it looks like two lines written over each other.

Please help

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
 
J

John Nurick

If it worked in the past, but not now, then something must have
changed...

Use a hex editor (such as Hexedit) to compare text files produced by
your machine and by your French colleague's. Are they formatted the same
(record separators, field separators, text delimiters)? If so, the
problem is in the software that reads the text files. If not,
consideration of the differnces should point towards the next
troubleshooting steps.


Hello John,

I'm sorry about not being clear. The transfer text method
in the macro is using a specification that uses ¶ as the
delimiter. This has worked fine in the past. Just
recently the French team has encountered this problem.
-----Original Message-----
Hi David,

At a guess this is because of the different default field separators in
France (and most continental countries) and the UK.

Here, the separator (delimiter) is usually a comma. There, the comma is
used for the decimal point so is not available as a field separator, and
the semicolon is used instead.

It could be that your software is exporting a comma- delimited file which
is confusing the French software. One way round the problem might be to
export it as tab-delimited instead.


I have a macro that uses the transfer text method to
export a table to a delimited text file.

On my pc, it works fine. When my guy out in France uses
it. The text file seems to be overwriting some lines so
it looks like two lines written over each other.

Please help

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top