找不到元素mysqlforexcel,MySQL for Excel加载项，无法追加

I am using the MySQL for Excel add-in. I have been using this for months to highlight a set of data and load it into my database.

I added a new table last week, and was successfully loading data into it using the same method. It stopped working. When I attempt to Append data, I get an error dialogue box that says "Cannot Find Column 30"...which happens to be the number (and therefore) last column in my table.

Some more information:

- If I highlight this same set of data and try to write it to another table, it will allow me to (even though I don't confirm and do it). I get past the error dialogue box to the Mapping dialogue box.

- I tried writing data from the previous table to this new problem table. I got the same error dialogue box.

This tells me that the problem is not with the data set. It is with the table.

I then deleted the table, all the connections and redid it from scratch. Still the same problem.

Where is this failing? Thank you.

解决方案

ya even i had the same problem, even i tried the same way u did, like deleted the table recreated everything, it did not work, finally i tried to append some random table and went to "Advanced Options" at the bottom of the append pop up

in this u will see some "Stored Column mappings" and some mappings in it, now delete all of them and hit "Accept" now u can append the table

it will work