Code for space delimiter for exporting data

[Sandy]

Hello!

I need to export a table to a text file using spaces as
delimiters and not the default comma. Does anyone know
what code I need to place in the TransferText line to
designate a space?

Sandy

 

[Bruce M. Thompson]

I need to export a table to a text file using spaces as

delimiters and not the default comma. Does anyone know
what code I need to place in the TransferText line to
designate a space?

You need to create a "schema" or export specification that you can pass as the
"Specification" argument in the TransferText method. This is done by doing an
export using the Export command on the file menu which opens the export wizard
where you set up the export, including your delimiter type (see the "Advanced"
button in the wizard, where you also save the specification under a name that
you choose).

See "TransferText Action" and "TransferText Method" in Access Help.

 

[Sandy]

Thank you very much. I'll give it a try.

Sandy

-----Original Message-----

You need to create a "schema" or export specification that you can pass as the
"Specification" argument in the TransferText method. This is done by doing an
export using the Export command on the file menu which opens the export wizard
where you set up the export, including your delimiter type (see the "Advanced"
button in the wizard, where you also save the

specification under a name that