export to Excel creates "Outline"

[Loralee]

I am working in Access 2003. I have provided a button that allows the user
to create a "data dump" based on a 2 table SQL statement, into an Excel file.
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?
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

 

[Paolo]

Hi Loralee,
first dump the data from your SQL statement in an Access table and then
export to XL this table. In this way the resulting file should be "flat".
To dump the data in an access table transform your select query in a make
table query.

HTH Paolo

 

[Ralph]

I wonder if it is a setting in Excel? On the Data menu in Excel if you select
Settings is the Automatic styles check box selected?

 

[Loralee]

I checked and it doesn't change whether I check that box or not. It did what
I wanted in Office 2000!

I may just have to create a table or update the queryDef object but I'd
rather not fiddle alot if I don't have to. If I spend alot of time on
re-creating the feature for a user to do via the button ( few times a year),
I'd do better to just get in their and create the dump file myself and put my
time into something that will bring a better return for us.