Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lmnorms
8 Posts |
 Posted - 2009-03-08 : 14:39:32
|
| Hello,I currently have a VB.Net program that connects to a excel workbook.Works great locally but when I run a scheduled job through reportmanager on the server; I get an error. The error is: Comexception(0x800A03EC) "FilePath\File" Could not open excel.I understand that this is a common exception for running theInterop.Excel.My questions are:1. Can this error be fixed? I have not found any research thatsupports this.2. Would it be better if I switched to a ODBC connection to read thruthe excel file via an sql query?Thank you in advance for your comments. I apologized if this is the wrong forum for this question, I didn't know where else to put this topic.Patrick |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-03-12 : 11:11:08
|
| Verify that this is definitely an Excel error rather than wrong path / permissions.E.g. change the read of excel file to just display some file names in the folder or read a text file etc. If you can NOT access one of these then it's probably an error of file path, or lack of permissions.If you can access these - it is probably Excel problem as you thought. RE: previous post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121182Have you tried importing Excel file into a table via SQL Server? |
 |
|
|
|
|
|
Queestion about schedule report manager