FlyerTalk Forums - View Single Post - Excel Clinic - Adding a Connection to a Table
Thread: Excel Clinic - Adding a Connection to a Table
View Single Post
Old Apr 26, 2021 | 6:31 pm
  #5  
nerd
FlyerTalk Evangelist
All eyes on you!
20 Years on Site
 
Join Date: Jun 2002
Location: n.y.c.
Posts: 14,059
Power Query is the way to go. You can also use your existing table as a PQ data source, then append it to the Oracle data source, before bringing it back into Excel, if it needs to be seamless to the end-user (Power Query can merge/append/join, etc).
nerd is offline  
Reply