Forum Discussion
Unable to connect to Access database
- 4 years ago
Hi a_rp ,
According to your description, there are four solutions that can be tried for such problems:
- Change the version of Power BI Desktop to match the bit-version of your Microsoft Office installation.
- Change the bit-version of Microsoft Office to match the bit-version of your Power BI Desktop installation:
- If the error occurs when you attempt to open an .XLS file (an Excel 97-2003 workbook), you can avoid using the Access Database Engine by opening the .XLS file in Excel, and saving it as an XLSX file.
- If the previous three solutions are not feasible, it's possible to install both versions of the Access Database Engine.
For more details, you can read related document as below:
Troubleshoot importing Access and Excel .xls files in Power BI Desktop
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi a_rp ,
According to your description, there are four solutions that can be tried for such problems:
- Change the version of Power BI Desktop to match the bit-version of your Microsoft Office installation.
- Change the bit-version of Microsoft Office to match the bit-version of your Power BI Desktop installation:
- If the error occurs when you attempt to open an .XLS file (an Excel 97-2003 workbook), you can avoid using the Access Database Engine by opening the .XLS file in Excel, and saving it as an XLSX file.
- If the previous three solutions are not feasible, it's possible to install both versions of the Access Database Engine.
For more details, you can read related document as below:
Troubleshoot importing Access and Excel .xls files in Power BI Desktop
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- a_rp4 years agoFrequent Visitor
Hi v-henryk-mstf #b is what I could adopt and it did solve the issue. Thanks.
- v-henryk-mstf4 years ago
Community Support