Hello,
I refer this http://www.aspsnippets.com/Articles/Save-and-Retrieve-Files-from-SQL-Server-Database-using-ASPNet.aspx link of yours to save excel file in to mysql using vb.net as front end, i could save file of maximum 500 rows of excel sheet, but i have excel having 2 lakhs rows for this iam getting error as data too long for column 1 and i could not find varinary(max) in mysql
Regards,
Surya
Hi ISGSurya,
In mysql use LONGBLOB and change column1 type to LONGTEXT because type of VARCHAR() has just 255 characters.
© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.