Read Excel file in Oledb connection in C#

See more:

C++

Hi frds,

I am read the Excel file in oledb connection., In my local path its work fine..,

but in i am mention server path is not working i am getting error please check the code..,

MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Excel 12.0 Xml;HDR=YES; Data Source = 'C:\\CALIBRATION_FABTECH\\Calibration_Alert\\CALIBRATION STATUS.xls'; ");

Server Path:

MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Excel 12.0 Xml;HDR=YES; Data Source = '@:\\serverName\\CALIBRATION_FABTECH\\Calibration_Alert\\CALIBRATION STATUS.xls'; ");