I am currently developing a VBA program that automatically connects the pivot table to an MS Access database. My problem is how can I make my program flexible to handle different databases like SQL Server or Oracle. Is it possible to generate a different connection string at run time?
Any help will be appreciated.