[Solved] Assistance Needed for Excel Connection Error in Axpert

Axpert Web 11.x

Last Post by Axpert Support 1 year ago

2 Posts

2 Users

0 Reactions

533 Views

RSS

Posts: 609

Banupriya

Topic starter

Oct 15, 2024 7:51 am

(@banupriya)

Noble Member

Joined: 2 years ago

We are encountering the error: "Unable to connect to Excel; make sure the given file is a valid Excel file." Although we have downloaded and installed the OLEDB driver, the issue persists. It appears that the OLEDB driver version (32-bit) must match the Axpert version (64-bit), and the bit version of the OLEDB driver should also correspond to the Excel version (32-bit).

Could you please clarify if there are any alternative solutions to resolve this issue? Do we need to install the 64-bit version of Excel, or is there another approach we can take? This matter is urgent, as the client is currently unable to use the Excel functionality due to this error.

1 Reply

Posts: 602

Axpert Support

Admin

Oct 15, 2024 7:52 am

(@axpertsupport)

Honorable Member

Joined: 2 years ago

It seems there may be a bit mismatch between Axpert and MS Excel. Please verify that both are using the same bit version. If they match, install the corresponding bit version of the Access Database Engine; I have shared the link via WhatsApp.

If there is a mismatch—such as Axpert being 64-bit and Excel being 32-bit—please follow these steps to install the Microsoft Access Database Engine 64-bit:

1. Download the Installer.

2. Open Command Prompt: Run as administrator.

3. Navigate to the Installer Location: Use `cd` to change the directory.
Example:
`cd C:\users\admin\downloads\`

4. Run the Installer: Execute the installer with the `/quiet` or `/qn` parameter.
Example:
`MyInstaller.exe /quiet`
(Replace MyInstaller.exe with the actual filename of the installer.)

5. Wait for Installation: The process will proceed silently.

6. Verify Installation: Check the installation status once completed.

2 Forums
18.2 K Topics
18.9 K Posts
5 Online
3,336 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

PLATFORM

RESOURCES

THE COMPANY

Agile Developer is designed for introducing, instructing and training of Axpert developers for ease of use of the product. Although tutorials, references, and examples are regularly checked for inconsistencies, we can guarantee that the content is sufficiently and entirely accurate to the best of our knowledge with exceptions. You agree to have reading our terms of use and accepting them before using Agile Developer.

Ask Axi

[Solved] Assistance Needed for Excel Connection Error in Axpert