List index out of bound (8)

I want to import data from excel file (xlsx) to oracle DB table using Toad, but I get this error message.

I’m using the Import Table Data option under the Database / Import tab

Can anyone help me with this error?

What version of Toad?

Hi! The version is: 12.1.0.22

I don’t remember any specific problem with that version, but you might want to try saving the file as XLS instead of XLSX. If that doesn’t help, you can send me the file and table definition by email (john.dorlon@quest.com) and I’ll help you get it imported.

I forgot to mention that last week it worked without problem.

Well that’s something. Maybe a reset of user files will solve the problem. (Utilities -> copy user settings -> Reset to a clean set of user files). That will make Toad look like it was freshly installed.

It’s hard to tell you exactly what’s happening without being able to reproduce it. A screen shot of the error and window behind it might help. And let me know what the last thing you clicked was right before the error.