[AccessD] Export to excel

Hi Chester,

I've never had good luck exporting reports to Excel. Seems as the
column and page headings confuse the export process and it sets up
columns in the output file for those. I've sometimes been able to
adjust the column and page headings to minimize this problem. But the
queries themselves always export great so that is what I do. There
also could be a slight variation in the version of the excel file for
what is created by the menu driven option verses the code driven way.
So perhaps that is catching you.

Not much help really for you I'm afraid though. Best of luck getting
it working to your liking.

GK

On Wed, Nov 9, 2011 at 10:53 AM, Kaup, Chester
<Chester_Kaup at kindermorgan.com> wrote:
> I am resurrecting a database I created several years ago in Access 2003. On my custom menu bar on a report I have an icon to export to excel. When it exports there are columns in the excel file that are not in the report or in the query that the report is based on. What might my export to excel button be doing behind the scenes I have forgotten about? If I simply right click on the report and export the correct columns show up.
>
> Thanks.
>
>
> Chester Kaup
>
> Engineering Technician
>
> Kinder Morgan CO2 Company, LLP
>
> Office (432) 688-3797
>
> FAX (432) 688-3799
>
>
>
>
>
> No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com