question

NorbertPozsonyi-9574 avatar image
0 Votes"
NorbertPozsonyi-9574 asked emizhang-msft commented

Microsoft Excell CSV inport error

Hello i have problame with the Exel data import from CsV/Text file. Some modul cannot be found for using the modul. So i tryed to reinstall the office on clean way. I have Revo uninstaller pro for all components remove. Then reinstalled 2021 preview version. Before and after it notece me about the same error. I cant found any solution for this problame. The CsV file is errorless, i have no idea for any solution.

79847-error.png


office-excel-itpro
error.png (122.2 KiB)
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.

NorbertPozsonyi-9574 avatar image
0 Votes"
NorbertPozsonyi-9574 answered NorbertPozsonyi-9574 edited

Here is an other screenshot from structure of CSV

79860-contain.png



contain.png (110.1 KiB)
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.

emizhang-msft avatar image
0 Votes"
emizhang-msft answered

Hi @NorbertPozsonyi-9574,

According to the information you provided. I have the following 2 questions.

  1. When did the issue start? Is the issue with importing .txt files?

  2. How did you install the preview version of Office 2021?

Besides, is your Office 2021 32-bit or 64-bit? If it is 32-bit, you could try to change the Office from 32-bit to 64-bit to check the issue.

Have you installed other versions of Office before? If yes, please check whether other versions of Office have this issue?

Hope the information is helpful to you. Any updates, please let me know.


If the response 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.

NorbertPozsonyi-9574 avatar image
0 Votes"
NorbertPozsonyi-9574 answered emizhang-msft commented

None of import operation woked yesterday. It's include .txt yes.

I installed it from download center and it was trial before reinstalled windows.

But i tryed some solution and one worked: I used Microsoft Support and Recovery Assistant to fuly uninstall the product remains. And downloaded the office development tool to install the latest one version of it. That was worked only. After isntallation problem just disappeared.. But Issue was with powr query becouse when i directly load in thes files it worked perfectly if the delimiters is ';' . But after power query prepared the query and just would export back to exel it dispalyed the above error.

· 1
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.

Hi,
It seems your problem is resolved, it's glad to hear this information. I suggest you click "Accept Answer" and upvote it, Other partners who read the forums with the same issue can get more information from the correct result.
If you need more help, please feel free to let me know, I'm glad to help you.

0 Votes 0 ·