Transfer Text Error

  • Thread starter Thread starter David
  • Start date Start date
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
 
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.
 
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
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
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
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
Back
Top