saving table to txt file with no dividers

  • Thread starter Thread starter Cheryl Fischer
  • Start date Start date
Tzur Karelitz said:
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.
Click to expand...

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.
 
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
___________________________________
 
Tzur Karelitz said:
Thanks for the responses.
I actually ended up using the:
open
print
close
method for printing text to a file, which worked just fine.
Click to expand...

Yes, that's a fine alternative.
 
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
 
Back
Top