Transfertext export problem

[bjreb]

I am trying to export a table using tranfertext. The major stumbling point is that the file must have the extension .add. IS there a way I can add this to extensions?
I am running 2003 on server 2003.

Please help

Thanks

Andy

 

[gemma-the-husky]

cant you just save the file as "myfile.add", in the transfertext method

or does that give you "myfile.add.txt"

 

[bjreb]

It gives me an error when I try to save it as .add, if I save it as .txt I get no error

 

[pbaldy]

You may be able to create it as a txt file and then use the Name statement in VBA to change the extension.