Test everything locally OK.
To the server to test various errors, first installed office2010, and installed Accessdatabaseengine, then reported that "Microsoft Excel cannot access the file
Possible causes are: 1 The file name or path does not exist.
2 file is being used by another program.
3 The workbook you are trying to save has the same name as the currently open workbook. "Baidu, the COM component has been set: 1). Start--〉 Run--〉cmd
2) at the command prompt, enter mmc-32 and open the 32 console
3). File menu, add Remove Snap-in--〉 component service
4). In the DCOM configuration, locate the Microsoft Excel application, right-click on it, and then click Properties to pop up the Microsoft Excel Application Properties dialog box
5). Click on the "Logo" tab and select "Interactive User"
6). Click on the "Security" tab, click "Customize" on "Launch and Activation Permissions", then click on the corresponding "edit" button to add a "NETWORK SERVICE" user in the "Security" dialog box (note To select this computer name) and give it "local launch" and "local activation The permissions
7). Remain the "Security" tab, click "Customize" on "Access", then click "Edit" and add a "NETWORK SERVICE" user to the "Security" dialog box that appears, then give "Local access" permission.
Error Still,
found when viewing Web. config
<identity impersonate="false" />
Change it to
<identity impersonate="true" userName="***" password="****" />
Solve
Problems encountered with OLE DB import into Excel
