I have been using postgresql with pgadmin without any problems. But now I get Import Wizard error 9 when trying to import my xls file. It says "Subscript out of range". What are the possible workaround for this?
Import Wizard Error 9 in Pgadmin Possible Workaround
Hello Catherine Brewer,
Hope that my message finds you well.
I think that you will get this error if Excel not able/ can’t find some sheet that you are using maybe because you rename it.
For example if you have sheet with name “Sheet5” and you rename it to “SheetABC” then Microsoft Excel will not find it.
If you want to avoid like this errors use CODENAME of the sheet.
Hope this solution will help.
Kind regards,