Share via

How to resolve this error "External component has thrown an exception" in MS SQL server while loading excel file ?

Anonymous
2024-03-24T08:18:51+00:00

I am working on a data analysis project using MS SQL SERVER and facing an error while trying to load data from excel file. No file format is getting loaded in database and this error pops up every time "External component has thrown an exception". This is happening suddenly as i was using ms sql server but just i tried to load an excel file with 2lakh rows of data which was uploading only 57K rows. After this no file is getting loaded and same error is showing. How to resolve the issue.

Windows for business | Windows Server | Directory services | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-07-29T12:35:33+00:00

    How I resolved this error:

    1. Go to Control Panel -> Programs -> Uninstall programs -> Uninstall all Access drivers (32-bit and 64-bit)
    2. If not installed, install 32-bit and 64-bit access drivers from this source https://www.microsoft.com/en-us/download/details.aspx?id=54920 , DON'T RUN YET!
    3. Go to terminal (not Powershell) -> go to downloads (or where you downloaded the access drivers to) -> run "accessdatabaseengine_X64.exe /quiet" -> then run "Accessdatabaseengine.exe /quiet"

    The order of access driver installation matters! I believe that the error is due to the incorrect driver installation order.

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2025-01-07T04:48:00+00:00

    thanks AnetaKahle

    worked for me

    but after restarting the laptop, the same issue is coming. Again i have to do these steps....

    anyother options

    0 comments
  3. Anonymous
    2024-03-25T06:39:15+00:00

    Hi Abhishek Suneja,

    Thank you for posting on the Microsoft Community Forum.

    From the description above, I understand that your question is about SQL .

    Sincethere are no developers working with SQL on this forum. For quick and efficient handling of your problem, I recommend asking your question again in the Q&A forum, where a dedicated technician will give you a professional and efficient answer.

    Here is the link to the Q&A forum.
    Q&A - Microsoft Q&A

    Click the "Ask a question" button at upper right corner to ask your question, and select "SQL " tag and other tags related to your productions.

    I hope the above information is helpful.

    If you have any questions or concerns, please feel free to let us know.

    All the best
    Neuvi Jiang

    0 comments