exporting to comma dilimeted text file with one-to-many relationsh

A

ArieBen

This project exports data from Quickbooks and formats them in Access to send
a text file to a warehouse. The data contain customer and order detail
information, whereby one customer can have more than one item on order. I
can create a report that does summarize the detail records under each
customer portion without repeating the customer info, but I cannot find a way
to export this to a clean comma seperated text file with double quotes around
each text field. On the other hand, when generating the text file from the
query, each order detail record repeats all the customer info, which should
only show up once at the beginning of each text record. Each text record is
identified by "SO" at the start, and each order detail record with "ITEM" at
the beginning of this portion. How can i suppress the unwanted repetition of
customer info at the beginning of each order detail record for the same
customer and export this to a text file?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating comma dilimited text file with one-to-many relationships 7
Export table in to multipe text files 1
Exporting Multiple rows to csv as one record 1
Enforcing item uniqueness 1
Text File Export VBA Script Help Please 2
Rounding difference in Access 2003 text exports 2
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
Relationship help please!!!! 2

Top