MySQL for Excel加载项，无法追加 [英] MySQL for Excel Add-In, failing to append

问题描述

我正在使用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.

我上周添加了一个新表，并使用相同的方法成功将数据加载到该表中.它停止工作了.当我尝试追加数据时，出现一个错误对话框，提示无法找到第30列" ...恰好是表中的最后一列(因此也是该列的数字).

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.

这在哪里失败?谢谢.

推荐答案

ya即使我遇到了同样的问题，甚至我也尝试了相同的方法，例如删除表重新创建了所有内容，但没有成功，最后我尝试了追加一些随机表，然后转到追加底部的高级选项"弹出窗口 在这里，您将看到一些存储列映射"和其中的一些映射，现在删除所有这些映射并单击接受"，现在您可以追加表了

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

它将起作用

这篇关于MySQL for Excel加载项，无法追加的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！