P
puneet122016
Guest
I am using the "Microsoft.ACE.OLEDB.12.0" to read .xlsx file using OleDBConnection.
myconnectionstring is
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\countries.xlsx;Extended Properties="Excel 12.0;HDR=Yes;IMEX=1";
But it gives message The Microsoft Access database engine cannot open or write to file. It is already used by another user.
It is confusing, as we are trying to read .xlsx file but "Microsoft Access database engine" is displayed in exception message.
Please assist.
Continue reading...
myconnectionstring is
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\countries.xlsx;Extended Properties="Excel 12.0;HDR=Yes;IMEX=1";
But it gives message The Microsoft Access database engine cannot open or write to file. It is already used by another user.
It is confusing, as we are trying to read .xlsx file but "Microsoft Access database engine" is displayed in exception message.
Please assist.
Continue reading...