Thank you for your suggestion Ken. I have tried this but not gone far. I can
set a different macro for each of the files that's no problem. I am getting
stuck when it comes to the delimiters. Where do you say tab or comma
delimited? And where do you set where the fields have "" or not?
Can you give me a screen shot maybe? My email is elco2005@hotmail.com
Many thanks.
You will need to create an export specification for each type of file. You
do this by manually beginning to export a table/query, and when the export
wizard window appears, go through all the steps until you get the last
screen (to do the actual export). On that screen, at lower left, you'll find
an Advanced button. Click that button. You'll get a screen that has all of
your settings displayed. Click the Save As button on that screen and choose
a name for the specification. Then you can cancel the export.
You then can use that specification in the TransferText action as the
SpecificationName argument.

Signature
Ken Snell
<MS ACCESS MVP>
> Thank you for your suggestion Ken. I have tried this but not gone far. I
> can
[quoted text clipped - 32 lines]
>> >
>> > Many thanks
John - 30 Dec 2004 20:49 GMT
Many thanks for taking the time to help me Ken. A happy new year to you.
Regards,
John
> You will need to create an export specification for each type of file. You
> do this by manually beginning to export a table/query, and when the export
[quoted text clipped - 42 lines]
> >> >
> >> > Many thanks
Ken Snell [MVP] - 30 Dec 2004 21:03 GMT
You're welcome. Good luck.

Signature
Ken Snell
<MS ACCESS MVP>
> Many thanks for taking the time to help me Ken. A happy new year to you.
>
> Regards,
> John