[AccessD] Tab delimited text file

Could you not write a function to export the file line by line, put the file
into a recordset, open a text file for exporting to and loop through the
recordset and print each line into the file using something like

 Print #FileNumber, YourRecordset.GetString(, , vbTab, vbCrLf, "");

Has worked for me in the past.

On 27 October 2011 12:47, Arthur Fuller <fuller.artful at gmail.com> wrote:

> 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?
> >
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com