Error copying table data - input string was not in a correct format

[Henry Jen]

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