Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error while Connecting to Excel Sheet & MS Access DB in WebDynpro

Hi All:

I've TWO issues to be clear as soon as possible. I've 2 databases, 1 is Excel File & 2 is Access DB(mdb) File.

I'm using JdbcOdbc driver to connect these two files:

For Excel: "jdbc:odbc:Driver={Microsoft Excel Driver {*.xls}};DBQ=filename&path";

Select Qry: "Select * from [Sheet1$]"

For Access:"jdbc:odbc:TestDB", where TestDB is System DSN using 'Data Sources (ODBC)'

These 2 works fine when i run them in a Standalone Java Class.

But when i run the SAME code in WebDynpro the following errors i'm getting:

For Excel: The Microsoft Jet Database Engine could not find the object 'Sheet1$'. Make sure the object exist that you spell its name and the path name correctly.

I've used tested with diff options, but always get the same error.

For Access: Data source name not found and default no driver specified.

What could be the problem with WebDynpro??

Do we need to configure anything else to use the DSN or Driver in the above said manner?? I've searched a lot in net, could not found the solution. I wud appreciate if any one solves the problem?

Thanks in advance,

Munna SAP

Not what you were looking for? View more on this topic or Ask a question