Forum Discussion

srilekha's avatar
srilekha
New Contributor
13 years ago

JDBC Request - Blank Response for Excel DB

I am trying to connect to an Excel DB. I used the Control Panel -> Administrative Tools -> Data Source (ODBC) to convert my Excel file into a DB using the "Microsoft Excel Driver (*.xls)". I was successful in connecting to the Excel Driver but I do not get a Response in the Table or XML view. I could see the query result on running the query from the SQL Query Builder interface of the JDBC Request step. But NO RESULT displayed on invoking the JDBC Request step. This is not the case for other DBs like MySQL, etc. Seems to be a BUG in Excel DB connectivity alone.

2 Replies

  • Jasper175's avatar
    Jasper175
    Frequent Contributor
    13 years ago

    I know this is an old request - but did you mean just using Data Source test Step and pointing to an Excel File? If so did you make sure it's not .xlsx extension? You have to save it to 97-2003 format