ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Connect a Template with the data source. (https://www.excelbanter.com/excel-programming/305582-connect-template-data-source.html)

bob

Connect a Template with the data source.
 
Hello!!
I am new into Excel, but I have knowledge in Access.
I have created a Template in Excel that shows the data how
it was requested.(One column has the Office Name and other
columns has data calculated and a chart)
How can I extract the information from an Access database
Table to fill out the Excel Template?

Any help will be appreciated. Any documentation to read
also will help a lot.

Thank you
Bob

Tom Ogilvy

Connect a Template with the data source.
 
Use ADO.

http://www.erlandsendata.no/english/...php?t=envbadac

--
Regards,
Tom Ogilvy

"Bob" wrote in message
...
Hello!!
I am new into Excel, but I have knowledge in Access.
I have created a Template in Excel that shows the data how
it was requested.(One column has the Office Name and other
columns has data calculated and a chart)
How can I extract the information from an Access database
Table to fill out the Excel Template?

Any help will be appreciated. Any documentation to read
also will help a lot.

Thank you
Bob





All times are GMT +1. The time now is 12:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com