Export query to excel - autorefresh

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi all

I am working on some management accounts but the end user has poor
excel/access skills so I need to automate everything.

The current set up is a query in access that is exported manually to excel
and then used to create a pivot table.

Every month the data is exported again and the pivot table range is updated
to take into account the new rows.

I would like to be able - from excel - to just refresh the data through a
button led macro or autorefresh by having a direct link between excel and
access.

------
The obvious choice was to use the import external data function in excel and
"rewrite" my query in "Microsoft query", but I can't get MS query to run an
IF function.

My IF function in Access is the following:

Amounts: IIf([Analysis]="A - Overheads",-[Amount]*[Allocation rate],-[Amount])


In advance, Thank you
 
Hi to all Group Member

yesterday I was searching from google som vedios
I hve just found a lagrest and greatest group of
online vedios on internet

which Is on daily bases
it updates vedios on daily bases
so must check it to keep intouch with the world to examine what is happing
in side our world

the link is
http://obm.itnews.googlepages.com

regards and thnanks

Asad ali
manager :E-Idea google Group
cell:+923217507176
Email:[email protected]
web:http://obm.itnews.googlepages.com
 
Back
Top