An error occurred uploading Excel: "Microsoft is not registered on the local computer. ace.oledb.12.0 "Provider Solution
Read Excel Provider
if (Filefullpath. IndexOf (". xlsx") > 0)
Strcon = "Provider=microsoft.ace.oledb.12.0;data source=" + Filefullpath + "; Extended properties= ' Excel 12.0; Hdr=yes;imex=1 ' ";
Else
Strcon = "Provider = microsoft.jet.oledb.4.0; Data Source = "+ Filefullpath +"; Extended properties= ' Excel 8.0; Hdr=yes;imex=1 ' ";
Workaround:
1. Download the Office system driver, note that it is 2007, the pro-Test 2010english version error, the cause is not further confirmed, the component
Http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe
2. Installing AccessDatabaseEngine.exe
3. Web application pool Settings "Enable 32 no Applications"-->true
After the above settings, upload 2010 version of Excel No problem, if the error still occurs, it should be the download component version error
Microsoft is not registered on the local computer. ace.oledb.12.0 "Provider Solution