question

AaiSync-4219 avatar image
0 Votes"
AaiSync-4219 asked emilyhua-msft edited

Cannot import csv etc. in Excel 2016 by query

I want to import csv via new query in Excel but get the following error.

"Microsoft Excel could not load a required component. This may have been corrupted or deleted. Reinstall the client software or database data source driver."

This is not only by importing csv also other extebnties don't work en give me the same error.
I did reinstall Office but noting get better.

How can i reinstal client software or drive ?? And witch drive or clientsoftware ??

Please help

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered emilyhua-msft edited

@AaiSync-4219

Could you please tell us which version of Office 2016 are you using?
Such as Office Professional Plus 2016.

How did you get the Office installation content?

Please go to Control Panel to perform a repair for Office.

If nothing helps, I would suggest you use Microsoft Support and Recovery Assistant to remove the Office completely and reinstall it again.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.