Excel Import Error

[niczak]

Greetings!

I had great success importing an .xlsx file last week but I just got an updated dump and now the following is happening.

1) I right click on the destination MySQL table and click 'Import Data'
2) I choose 'MS Excel 2007', select the file in the browser then click 'Next'
3) The correct destination table is already selected so I click 'Next'
4) An error is thrown which states: "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"

Is that error specific to the file or the table? What does it mean? Has anyone else run into this and had luck resolving it?

Thanks!

[niczak]

I was able to convert the source file to .xls and that appears to have solved the issue but I would still like to understand what the error means and how it might be resolved.

[.jp]

Hello,

Thanks for the post.

It seems the "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index" error is a bug in our tool. To fix it would be great if you send us the xlsx file through our site (Support -> Request Support). You should fill the contact form and attach the file. Also please send the DDL of the table you wanted to import data to.

Best Regards.