access to text file

[George Applegate]

I am using access 2007. I don't know if that makes a difference or
not. If I want to output an access query to a text file, it is
putting like a "printed grid" of the information in it.

For instance:

-------------------------------------------------------------------------------------------------
Emp | Date | Time | In/Out | Source | Location| ID |
------------------------------------------------------------------------------------------------
0001 | 04/29 | 10:50 | IN | AAXX | HOME | A
-----------------------------------------------------------------------------------------------
0002 | 04/29 | 11:30 | OUT | ZZBB | REMOT | B
------------------------------------------------------------------------------------------------

How can I put out just a columnar file, with no dashes or headings:

I just want it like this

0001 04/29 10:50 IN AAXX HOME A
0002 04/29 11>30 OUTZZBB REMOT B

If in excel and output to a text file I think this works or to a "prn"
file. I confess I am not smart enough to figure this out. I suppose I
can strip off the -'s and headings in another program...but there has
to be an easier way!?!?!?!?!?!?

Thanks,
ga

George Applegate
(e-mail address removed)

 

[Michel Walsh]

Are you using

DoCmd.TransferText

or cut and paste, or something else?



Hoping it may help,
Vanderghast, Access MVP

 

[George Applegate]

Michael,

Are you using

DoCmd.TransferText

or cut and paste, or something else?

Actually, I was just doing an "export" to a text file...

How do I do what you suggest - DoCMD Transfer Text? I'm a "low level"
access user


thanks,
ga

Hoping it may help,
Vanderghast, Access MVP

George Applegate
(e-mail address removed)

 

[Michel Walsh]

The easiest way is probably through a macro. Create a new macro, select
TransferText as action, fill the small subsheet in the bottom-left (small
comments are displayed, item by item, at the right), and run/test the macro.


Hoping it may help,
Vanderghast, Access MVP