[AccessD] Export to excel

Kaup, Chester Chester_Kaup at kindermorgan.com
Thu Nov 10 11:31:25 CST 2011


I figured out what I did on the toolbar. I created an icon that said export to Excel but actually ran a query and then exported the results to excel. Just needed to modify the query it was running.

At least we got some good discussion on exporting to Excel.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Wednesday, November 09, 2011 11:42 AM
To: Access Developers discussion and problem solving
Subject: Re: [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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list