Linked Query to excel (1 Viewer)

[NurulScare]

Hi, I want to create pivot from Query. I think the best way for me is to linked access query to excel. however I cannot find way to do that.

Can someone please advise:

 

[arnelgp]

from Excel, click on Data tab on the ribbon.
Get Data->From Database->From Microsoft Access Database.
select your database, and it will show the Table and Queries.
select the query you made and click Import.

 

[NurulScare]

from Excel, click on Data tab on the ribbon.
Get Data->From Database->From Microsoft Access Database.
select your database, and it will show the Table and Queries.
select the query you made and click Import.

I tried this for Table access linked to Excel. Thats okay but for Query nothing appear. Only list of table appear

 

[CJ_London]

if you are talking about linking a pivot query in access to excel, be aware you cannot export the pivot view of the query. However you should be able to see the queries - are you looking at the right db? tables will be in the BE, queries in the FE

 

[NurulScare]

if you are talking about linking a pivot query in access to excel, be aware you cannot export the pivot view of the query. However you should be able to see the queries - are you looking at the right db? tables will be in the BE, queries in the FE

No, i would like to linked my query to excel. so whenever there's a changes in my query, will reflect in excel as well. I tried to use VBA, however still cannot work because my query use Function "Nz"

 

[CJ_London]

change your nz(myfield,0) (or whatever you have as value to use if null)

to

iif(isnull(myfield),0,myfield)

once you have linked successfully, in excel you will need to refresh link to see changes

 

[arnelgp]

only Simple Select Query can be seen on excel part.