I have an excel file which has an excel connection to a external database with a connection string. It follows OLE DB query Connection String is
"Provider=SQLOLEDB;Data Source=DBSRV;Initial Catalog=Dare_Reporting;User ID= dareuser;Persist Security Info=true "
