| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can we connect Pivot to multiple source data (MS Access) | Excel Discussion (Misc queries) | |||
| Excel Service error "cannot connect to external data source" | Excel Discussion (Misc queries) | |||
| Change source according to data entered in a template. | Charts and Charting in Excel | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
| Need template source path | Excel Programming | |||
Linear Mode
