- How to create a report using a file with the extension .xlsx
- How to create a report using MS Excel XML file format. ( .xlsx format ).
- Unable to create a report off MS Excel file in Crystal Reports using the Access/Excel (DAO) connection type.
- How to create a report off MS Excel 2007, MS Excel 2010, MS Excel 2013, or MS Excel 2016 spreadsheet file format in Crystal Reports?
- SAP Crystal Reports 2008
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- MS Excel 2007
- MS Excel 2010
- MS Excel 2013
- MS Excel 2016
- DAO technology cannot be used to access the Microsoft Office 2007 and above file formats: Microsoft Access 2007 .accdb, Microsoft Excel 2007 .xlsx (XML) and .xlsb(Binary). These file formats are supported via the Microsoft 2007 Office System drivers for ODBC and OLEDB.
- To report off a MS Excel spreadsheet saved in the format (.xlsx) in Crystal Reports, using one of the following:
- An ODBC connection.
- An OLE DB connection.
- To use an ODBC Connection:
- Launch the 32bit version of the Microsoft ODBC Administrator.
- 1.1 If you are using a 32bit version of MS Windows, launch the MS ODBC Administrator by selecting
"Start - Control Panel - Administrative Tools - Data Source (ODBC)"
- 1.2 If you are using a 64bit version of MS Windows, launch the MS ODBC Administrator from the path:
- If you do not see the ODBC Driver, then it is either because you have a 64bit version of MS Office installed, or do not have MS Office installed. To download and install the 32bit version of the Mircoroft Office ODBC driver, go to the Microsoft website. ( Link for the 32bit version of the Microsoft Office ODBC Driver.)
Note: If the MS Excel sheets are not visible in the Database Expert then:
- Right click on the Connection, and in the contextual menu, select Options
- In the Options window, check the option System Tables, and click OK
- Back to the Database Expert window, right click on the connection, and select Refresh
- The MS Excel sheets will now display. Select the desired MS Excel sheet.
- To use an OLE DB connection
In Crystal Reports, create a new report.
In the Database Expert, expand Create New Connection, and double click on OLE DB (ADO)
Select the Microsoft Office 12.0 Access Database Engine Provider
If you do not see the OLEDB Provider, then it is either because you have a 64bit version of MS Office installed, or do not have MS Office installed. To download and install the 32bit version of the Mircoroft Office ODBC driver and OLEDB Provider, go to the Microsoft website. ( Link for the 32bit version of the Microsoft Office ODBC Driver.)
Change the Office Database type to: Excel
Select the MS Excel file.
Leave UserId and Password blank.
.xlsx, import MS Excel 2007, MS Excel 2007, import .xlsx file, .xlsx data source, crystal reports , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To