Create 1 .csv file from 3 tables of differing number of fields

[Guest]

I have 6 fields of data in one table that I need to use as a header in a .csv
file. I have 3 fields another table to be used a s a footer. With a third
table of 13 fields providing the core data.

How do I create the .csv output file from these 3 tables?

Your help will be much appreciated

Thanks

Charles

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExportFormattedFixed.MDB" which could be modified to do what
you want. Basically, you build each export line as a string and print it to
a file with low-level I/O. Instead of fixed width, however, you'd want to
add commas between your fields.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L