Import Wizard Error 9 in Pgadmin Possible Workaround

Asked By Catherine Brewer 10 points N/A Posted on - 12/05/2012

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?

• Status: Open
• Question Views: 971
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: PostgreSQL

Answered By May Jratr 0 points N/A #151951

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,

About May Jratr

Questions
2

Answers
100

Best Answers
31

• Vote Up 0 Vote Down

• Posted on - 12/14/2012
• Question Category: PostgreSQL