[AccessD] Tab delimited text file

I have had the same problem in the past and failed to come up with a
strictly-Access solution, so I adopted a more primitive method -- my
favourite text editor (NoteTab). It is lightning-quick and makes it a cinch
to do a global-replace, so I searched for "," and replaced it with "^T"
(which in NoteTab nomenclature means "Tab"). NoteTab can handle extremely
large files, too. I'm sure that other text editors can do this too.

Arthur

On Thu, Oct 27, 2011 at 7:17 AM, Debbie <delam at zyterra.com> wrote:

> I have a text file being exported from access 2007 using transfer text.
> This creates a comma delimited file that has been working fine. The
> receiving end of this file has asked for a tab delimited file instead. Our
> attempts to create an export specification to do this has not yielded
> anything transfer text will acknowledge. Does anyone know how to either fix
> the export specification or an alternate method?
>
>