This is crucial:
There may be error messages posted before this with more information
So you could take a look at the output window and post everything you find there here in the forum.
My first guess: BIDS is still configured to run in 64-bit mode, while the Jet/ACE OLE DB provider is only installed for 32-bit. Right-click on the project, go to properties and set the Run64BitRuntime to False.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP