This error always comes up when you are trying to import a wallet with old pruned data meaning it can't find any transactions from the current blockchain data.
This is my own solution that works to me but I do not know if it will work for you.
Try to disable the pruning mode first and close the Bitcoin core> Go to the blockchain data folder and delete all data and then open Bitcoin core again and enable prune mode again and let it sync.
Delete all but don't delete the wallets folder with wallet.dat file inside. Before doing this, OP must have a copy or some copies of the wallet.dat file.
In Bitcoin Core, OP can click on Windows, Information and get the Data direction (datadir).
Go to that folder, delete all sub folders, except wallets sub-folder. Close the Bitcoin Core, then open it again and let it download the block chain from Genesis block and syncs.