View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default 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