SAP Knowledge Base Article - Preview

1197753 - Error: "[Microsoft][Excel ODBC Driver] Syntax error in FROM clause" when attempting to create a universe from a Microsoft Excel source

Symptom

In BusinessObjects Designer version 6.5, a universe is created using a Microsoft Excel file. The ODBC connection is created, and the spreadsheet is brought in to the universe as a table. However, when clicking Data > View and attempting to run a report, the following error message appears:

"[Microsoft][Excel ODBC Driver] Syntax error in FROM clause".


Read more...

Product

SAP BusinessObjects Business Intelligence platform 6.5 ; SAP BusinessObjects Business Intelligence platform 6.5.3

Keywords

Microsoft Excel, universe creation , 3345014 , KBA , BI-RA , Reporting, analysis, and dashboards , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.