MySQL Forums
Forum List  »  MySQL for Excel

Error copying table data - input string was not in a correct format
Posted by: Henry Jen
Date: September 18, 2018 02:48PM

Hello,

I'm a beginner learning MySQL and MySQL for Excel. I'm trying to connect to MySQL from Excel to retrieve info but keep running into an error message.

There are 12 columns in this table, consists of 3 columns of int(11), 7 columns of varchar(50), 1 column of varchar(20) and 1 column of char(2) for vendor info.

###
Error
Error copying table data
Input String was not in a correct format.
###

The details show -

###
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)
###

I'm using -
Windows 7 Professional 64 bit with service pack 1. i7-4770 CPU with 8G RAM.
Microsoft Office home and business 2016
MySQL Server / Workbench / Connector/ODBC / Shell / Router 8.0.12
MySQL For Excel 1.3.7

Appreciate anyone pointing me to the right direction trying to figure out the problem.

Thanks.

Henry

Options: ReplyQuote


Subject
Views
Written By
Posted
Error copying table data - input string was not in a correct format
3383
September 18, 2018 02:48PM


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.