I'm using SSMS 2014 and I'm able to link an Excel file as a linked server. But here's my question: Now I want to link multiple Excel files. Can I link all of the files on a linked server or do I have to do them separately? Meaning one linked server for one Excel file.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!