Query to .csv or .txt

I have a very basic QUERY...I would like to "automate" moving the QUERY data
into a .CSV or .TXT file.

I have been trying to accomplish this with a MACRO.....and using the "OUTPUT
TO" argument....when I choose .txt as the Output format.....I end up with a
..txt file but part of this process is putting nice little boxes around all
the data. This is causing the file to fail when I attempt to upload it to
our bank.

I'm looking for any solution that will allow me to automate moving the QUERY
data into one of these 2 formats....but I need just a standard delimited
..txt/.csv file

Thanks for your time

W
.

Relevant Pages

  • Re: Report totals
    ... as I would like to have the dates covered print on the report. ... how to accomplish binding them to the parameters. ... source options the only choices are the fields in the query. ... then refer directly to the text boxes on the form in your DSumexpression. ...
    (microsoft.public.access.reports)
  • Re: Find Max of many fields
    ... how did you accomplish it. ... I started by having the query pull the values for all 25 boxes from ... >> syntax wrong somehow? ...
    (microsoft.public.access.forms)
  • Export QUERY to CSV or .TXT
    ... I have been trying to accomplish this with a MACRO.....and using the "OUTPUT ... ..txt file but part of this process is putting nice little boxes around all ... I'm looking for any solution that will allow me to automate moving the QUERY ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Formula in query
    ... I have a query with a formula that combines a series of textboxes to form one ... I would like a formula to return whatever is in any of my text boxes. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • RE: Find Max of many fields
    ... how did you accomplish it. ... "Tim" wrote: ... I started by having the query pull the values for all 25 boxes from ...
    (microsoft.public.access.forms)
Loading