I am working in Office 2003, and have created a form and procedures for a
user to create a "Data dump" from a report in Access 2003 to Excel. The
"data dump" is based on a 2 table SQL statement.
I WANT a flat file but I am getting an "outline" file; One level of the
outline is from 1 table and the other is from the second table (This used to
produce what I want in Office 2000.) I cannot figure out how to create the
"flat file" within Excel.

1) How can I create the "flat file" once the data gets to Excel? IS there a
setting I can change?
2) Is there an argument I can add to my VBA code in Access that will
produce a real "flat file"?

Thanks in advance-

Loralee

--
Loralee