on 2021 May 21 5:43 PM
I have Crystal Reports 2020 64 bit loaded on my laptop. The laptop is running a 64 bit version of Windows 10 pro. I am running the 64 bit version of MS Office 365. When I try to connect to an Excel .xls file I get the following message:
"Failed to load database information. Details: No database connector has be specified" (see attached screenshot)
This has not been a problem with previous versions of CR that I've used.
With newer versions of Crystal you have to configure an ODBC connection to Excel to get it to work as a data source because the JET engine that used to be available has been deprecated by MS. The Excel ODBC driver is part of the MS Access database engine which you can download from here: https://www.microsoft.com/en-us/download/details.aspx?id=13255. You'll need AccessDatabaseEnding_x64.exe.
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
When I try to 'create new connection' and I choose ODBC I see the excel ODBC, but it wants a user ID and password. That has never been required in the past. In older versions of Crystal I was always able to 'create new connection', then choose 'database files', then search for the file. In this case it would be an excel worksheet.
User | Count |
---|---|
71 | |
11 | |
10 | |
10 | |
10 | |
8 | |
7 | |
7 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.