Unable to import large text i.e. text >1024 characters from excel to sql database

Posted on 2006-03-31
Last Modified: 2012-05-05

I could do the it manually but how do i import excel to the database even if the text in excel has large text like >1024 characters. How do i do it. Please let me know.
Question by:estecher
    LVL 50

    Expert Comment

    what's the import failing with?

    is the text > 8060 bytes (4030 characters)    (is it text or Ntext varchar or Nvarchar?)

    will the "text" contain control characters CR LF x'00' etc..
    LVL 92

    Expert Comment

    by:Patrick Matthews
    Hi estecher,

    This question is a duplicate of:


    LVL 75

    Expert Comment

    by:Anthony Perkins
    Are you sure it is not importing correctly?  Or is it just not displaying all the data in Enterprise Manager?  Enterprise Manager cannot display more than 1K data.

    Author Comment

    The import is failing at the row which has more than 1024 characters, the data type of the cell is varchar(5000). I did some cells manually but i have many rows to do . Is there a better way to do?
    LVL 75

    Accepted Solution

    Please close this question, as you have now opened, in direct violation of the EE Guidelines a duplicate question here:
    LVL 75

    Expert Comment

    by:Anthony Perkins
    I appreciate the points, however I do not believe I have earned them.  See here from the EE Help:
    I accepted the wrong answer. Now what?

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now