What's the version of your Office?
Please go to Excel > File > Account > Product Information, check the version and number, then share the information with us.
Could you please take a screenshot of the error message? This behavior could help us understand your issue better.
Where is the information from? Does it comes from 3rd-party software?
And what's the format of this data file? Such as txt file, .xlsx file.
Please check whether the following articles are helpful.
Tutorial: Import Data into Excel, and Create a Data Model
Import or export text (.txt or .csv) files
Any updates please let me know.
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.