Outputting an Access 2003 Report to csv or txt

M

Morag Mitchell

I need to output data from two tables, the header info drawn from the "one"
and the rest of the data from the "many" table. I have created a report
which is grouped accordingly, but need to output this as a text file with
fixed width fields for import into Navision. This seems to be available for
tables but not for reports. Can you help please?
 
T

Tony Toews [MVP]

Morag Mitchell said:
I need to output data from two tables, the header info drawn from the "one"
and the rest of the data from the "many" table. I have created a report
which is grouped accordingly, but need to output this as a text file with
fixed width fields for import into Navision. This seems to be available for
tables but not for reports.
Click to expand...

Fixed width might be troublesome however I'd look at exporting from
queries not reports. You can do the grouping and such in queries.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Top