MySQL Forums
Forum List  »  MySQL for Excel

Exception thrown by: MySqlDataTable.CopyTableData
Posted by: Gerard Seibert
Date: December 28, 2018 05:10AM

Windows 10 PRO 64-bit
MySQL for Excel 1.3.7
Excel for Office 365 16.0.11213.20020 32-bit
MySQL VER 8,0.12 for FreeBSD12.0 on amd64

When attempting to open some, but not all, SQL databases, this error message is displayed:

Exception message:
Input string was not in a correct format.

Exception thrown by:
MySqlDataTable.CopyTableData

Stack trace:
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at System.String.System.IConvertible.ToInt32(IFormatProvider provider)
at System.Data.Common.Int32Storage.Set(Int32 record, Object value)
at System.Data.DataColumn.set_Item(Int32 record, Object value)

This only occurs on some databases.

Options: ReplyQuote


Subject
Views
Written By
Posted
Exception thrown by: MySqlDataTable.CopyTableData
1166
December 28, 2018 05:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.