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

[rjbautista20]

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.

[Shaggy Hiker]

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.

[rjbautista20]

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.