Populate values in Excel worksheet from Access table

[aman1234]

Hi All

I want to write down the code that will populate values in "Sheet1" from the Access table. The column headers shows "Envelope types", "Envelope Size" fields from the Access table and each cell should store sum(volume) for each month in the table.

As I can't upload access table in the attachment so I have exported data into Workbook named "tblmain" as attached. But in actual tblmain is Access table. So please consider it an access table.

I hope anyone can help me in wrting code that will fetch data from access table and store in all the cells of the table in "Sheet1" of Elevate workbook.

Thanks

[adyteo]

why don't you create a connection to Access database that will populate your table in sheet1?

[aman1234]

Hi, I don't want to populate the whole table in sheet1. In actual I want to display the sum(volume) for each field of the table in the sheet1 cells.I know I need to create a connection with Access database. The below is the code for that but how to populate those values in the sheet1 cells.

Please Login or Register  to view this content.

please help me in this.

Thanks

[aman1234]

The following code is used to populate value in cell(4,"B")

Please Login or Register  to view this content.

But there are lots of cells where I want to populate values so if I close the recordset and open it again and so on , it will be very complicated. Is there any short way to do this.

Thanks

[adyteo]

can you create a table in Access where you store all values you are interested in and then import them into excel?

[aman1234]

Hi guys

Can anyone please help me int his?

Regards,
Aman

[aman1234]

Hi All

The following code populates data for february month in the table. Then for the next months I need to write down the same lines of code but for different month. But is there any short way of doing it. Any help would be much appreciated.

Please Login or Register  to view this content.

[wcymiss]

try this:

Please Login or Register  to view this content.