All about SharePoint: Writing the code for connection string for MS-Excel in C#.NET.

Please find below image for your reference, follow red line on attached image that will help you to add connection with xls file.

Starts from server explorer(LHS in vs) and try to add new db connection then follow attached image.
Hopefully this will resolve your problem.