saving table to txt file with no dividers

[Cheryl Fischer]

Check out the TransferText method in VBA Help.

 

[Dirk Goldgar]

Hi,
I want to save a table from the VBA code. I have been using the
outputTo command, but the resulting txt file has dividers ( like |
and _ ) which I need to delete. Anyone knows how to save a table (or
a query) so that they won't be saved with deviders?
Thanks.

Use DoCmd.TransferText instead. If you don't want to use delimited
format (acExportDelim), you must first create and save an import/export
specification, so you can give the specification name in the
TransferText arguments. You can create such a specification by
initiating an import process via File -> Get External Data -> Import...,
starting the Text Import Wizard, then before (or instead of) finishing
the import clicking the Advanced... button and saving the specification.

 

[Tzur Karelitz]

Hi,
I want to save a table from the VBA code. I have been using the outputTo
command, but the resulting txt file has dividers ( like | and _ ) which I
need to delete. Anyone knows how to save a table (or a query) so that they
won't be saved with deviders?
Thanks.

--
Tzur.
___________________________________
Tzur Karelitz
Department of Psychology
University of Illinois at Urbana Champaign
217-356-6573
ICQ#- 121732029
MSN MSG- (e-mail address removed)
http://www.psych.uiuc.edu/~karelitz/default.htm
___________________________________

 

[Dirk Goldgar]

Thanks for the responses.
I actually ended up using the:
open
print
close
method for printing text to a file, which worked just fine.

Yes, that's a fine alternative.

 

[Tzur Karelitz]

Thanks for the responses.
I actually ended up using the:
open
print
close
method for printing text to a file, which worked just fine.
Tzur