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...

Thank You 🙂

Hi All,

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...

Thanks everyone for the replies 🙂

@jack-2

Wow, that is nearly what I need. Special thanks to you.

Trying it now & just trying to figure out a way to collate the...

Thank you. That worked perfectly 🙂

Regards,

RP