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
|