| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to change de data base of a dinamic table
I have Dinamic Table in Excel XP. This table takes de data from an Access
Data Base. What I need to do, is ti change the Data Base, but I do not want to remake the dinamic table. How can I do this? Thanks a lot, Lina |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to change de data base of a dinamic table
The data only travels in one direction. From Access to Excel. To send data in
the other direction requires a whole pile of VBA using ADODB Recordsets... Unless you are confident in your VBA then you are out of luck. If you are confident with your VBA reply back and I can send you some generic code to get you started... HTH "Lina Manjarres" wrote: I have Dinamic Table in Excel XP. This table takes de data from an Access Data Base. What I need to do, is ti change the Data Base, but I do not want to remake the dinamic table. How can I do this? Thanks a lot, Lina |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to change de data base of a dinamic table
Thanks a lot,
What I really need is the posibility to change the data base where I am getting the data from. I mean, the access data base use to be data from 2004, now I want the data from 2005 data base. But I do not want to make the dinamic table again. "Jim Thomlinson" wrote: The data only travels in one direction. From Access to Excel. To send data in the other direction requires a whole pile of VBA using ADODB Recordsets... Unless you are confident in your VBA then you are out of luck. If you are confident with your VBA reply back and I can send you some generic code to get you started... HTH "Lina Manjarres" wrote: I have Dinamic Table in Excel XP. This table takes de data from an Access Data Base. What I need to do, is ti change the Data Base, but I do not want to remake the dinamic table. How can I do this? Thanks a lot, Lina |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Table at Base of Chart | Charts and Charting in Excel | |||
| Does anyone have an example data to base a Pivot Table on? | Excel Worksheet Functions | |||
| How can I change 0's in the data set to do a LOG with base 2? | Excel Worksheet Functions | |||
| How to dinamic cell that searches for "value1 & value2" in table. | Excel Discussion (Misc queries) | |||
| Excel error using Dinamic Table | Excel Worksheet Functions | |||
Linear Mode
