Results 1 to 8 of 8

Thread: Excel 255 character limit for a cell? [Resolved]

Threaded View

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2000
    Location
    Mobile, AL, USA
    Posts
    600

    Unhappy Excel 255 character limit for a cell? [Resolved]

    Hi.

    I'm transferring data from an Excel spreadsheet to a SQL Server DB via ADO. The code works as expected, but all of the data is not transferred over if a cell contains more than 255 characters - in other words, it is truncated. Does anyone know why this is happening? Better yet, a solution for the problem!

    Thanks,
    OneSource
    Last edited by OneSource; Aug 2nd, 2004 at 12:55 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width