# List index out of bound (8)

**URL:** <https://forums.toadworld.com/t/list-index-out-of-bound-8/38208>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [August 17, 2016, 10:37am UTC](https://forums.toadworld.com/t/list-index-out-of-bound-8/38208 "2016-08-17T10:37:22Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![N10ram](https://avatars.discourse-cdn.com/v4/letter/n/4491bb/32.png) [@N10ram](https://forums.toadworld.com/u/N10ram)\
**Post date:** [August 17, 2016, 10:37am UTC](https://forums.toadworld.com/t/list-index-out-of-bound-8/38208/1 "2016-08-17T10:37:22Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [August 17, 2016, 10:51am UTC](https://forums.toadworld.com/t/list-index-out-of-bound-8/38208/2 "2016-08-17T10:51:55Z")

</div>

What version of Toad?

---

<div class="post-metadata">

**Author:** ![N10ram](https://avatars.discourse-cdn.com/v4/letter/n/4491bb/32.png) [@N10ram](https://forums.toadworld.com/u/N10ram)\
**Post date:** [August 17, 2016, 10:56am UTC](https://forums.toadworld.com/t/list-index-out-of-bound-8/38208/3 "2016-08-17T10:56:12Z")

</div>

Hi! The version is: 12.1.0.22

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [August 17, 2016, 10:59am UTC](https://forums.toadworld.com/t/list-index-out-of-bound-8/38208/4 "2016-08-17T10:59:09Z")

</div>

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](mailto:john.dorlon@quest.com)) and I’ll help you get it imported.

---

<div class="post-metadata">

**Author:** ![N10ram](https://avatars.discourse-cdn.com/v4/letter/n/4491bb/32.png) [@N10ram](https://forums.toadworld.com/u/N10ram)\
**Post date:** [August 17, 2016, 11:02am UTC](https://forums.toadworld.com/t/list-index-out-of-bound-8/38208/5 "2016-08-17T11:02:25Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [August 17, 2016, 11:07am UTC](https://forums.toadworld.com/t/list-index-out-of-bound-8/38208/6 "2016-08-17T11:07:41Z")

</div>

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.