Devart Forums

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!

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.

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.