Thank you for the reply. I tried but was not successful to make linked server to excel work. Though I used openrowset query with INSERT INTO and it solved my...
I have tried and finally included temp tables to collate all the data and also added the functionality to check whether the server contains Database1 or Database2. Here...