MySQL Forums
Forum List  »  MySQL for Excel

Value was either too large or too small for an unsigned byte
Posted by: William Marriott
Date: September 19, 2013 02:30PM

I'm pulling in a table from MySQL into Excel to edit using the 1.1.1 plugin and I'm receiving the following error due to the fact that the table contains negative values:

Value was either too large or too small for an unsigned byte.Couldn't store <-1> in q129 Column. Expected type is Byte.

at System.Data.DataColumn.set_Item(Int32 record, Object value)
at System.Data.RecordManager.CopyRecord(DataTable src, Int32 record, Int32 copy)
at System.Data.DataTable.ImportRow(DataRow row)
at MySQL.ForExcel.MySQLDataTable.CopyTableData(DataTable filledTable)


Is there anyway to change the default field format to allow for these values to be passed to excel without this error?

Thanks, Scott

Options: ReplyQuote


Subject
Views
Written By
Posted
Value was either too large or too small for an unsigned byte
5635
September 19, 2013 02:30PM


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.