I know it is possible to pull data through from excel from multiple databases. I have a basic understanding of sql (Microsoft server management studio) and I have been playing around with the Data tab "import from other sources" tab.
Now here is where it gets overwhelming. Do I use OLEDB or ODBC or can I query straight from sql? and if so guide me in getting this information into one dataworkbook. I know how to use the select function to select certain columns but it seems at this stage i will have to combine 2 tables per database. (3 databases in total).
ANY guidance welcome.
PS pulling the info from Pastel evolution so if you have a smart BIC person out there to help please! (I only have standard not advanced version)