Getting Data from MS Access and put in specific cell in excel

Hi Good day,

i would like to ask on how to get a specific data in a query in ms access and put the result to a speicific cell in excel?

Thanks for help.

In which language? If it is .NET, I have an Excel class over in the .NET CodeBank that saves datatables or datareaders into Excel forms. You could start with that and modify the cells that are being updated.

HI,

Thanks for your reply. I'm using Excel 2010 VBA.

Here's Scenario: I already created a crosstab query to produced the calculated data. and What i'm gonna do is to get the data from that query to a specific cells in excel.



Thanks.