There is a known problem with the Oracle Primavera P6 Export option. Sometimes you receive an error message that says that Primavera P6 Excel Import/Export Requires Microsoft Access Database engine while you trying to export the project from primavera to excel.
The solution is quite simple. You need to install Microsoft Access on your PC or do the following steps:
1- Go to your This PC then Uninstall or change the program
2- Search for Access word and remove all Access Database engine
3-Download and Install this one
It should work with these steps.