When I am connecting excel as a database, the no.of characters in my excel columns when exceeding a certain limit gets truncated in my excel file. Is there any limitation in regards to characters or any exact count which should be maintained? Or is there any format like based on first n rows of excel file, the no.of characters are limited for others rows as well ?
Page 1 / 1
https://learn.microsoft.com/en-us/sql/odbc/microsoft/column-name-limitations?view=sql-server-ver16
My Observation on this- If we try to insert text using Excel as DB with more than 255 characters in a cell, it will fail or truncate. Workaround to this is to insert long text in any cell above the current one (in same column) say 1000 characters then we are able to insert upto that many characters in any cell below that.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.