Code for space delimiter for exporting data

  • Thread starter Thread starter Sandy
  • Start date Start date
S

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
 
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?
Click to expand...

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.
 
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
Click to expand...
specification under a name that
 
Back
Top