c# - Error using Data Source relative path in Excel Data Driven Unit Test -
i using system.data.odbc connection string connect excel data source. following error occurs when using relative dbq path: error [42s02] [microsoft][odbc excel driver] microsoft office access database engine not find object 'sheet1$'. make sure object exists , spell name , path name correctly. app.config: <configuration> <configsections> <section name="microsoft.visualstudio.testtools" type="microsoft.visualstudio.testtools.unittesting.testconfigurationsection, microsoft.visualstudio.qualitytools.unittestframework, version=10.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a"/> </configsections> <connectionstrings> <add name="excelconnection" connectionstring="dsn=excel files;dbq=exceldatasource.xlsx;defaultdir=.;driverid=790;maxbuffersize=2048;pagetimeout=5" providername="system.data.odbc"/> </connectionstrings> <microsoft.vis