We help IT Professionals succeed at work.

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

estecher
estecher asked
on
Medium Priority
209 Views
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.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2011

Commented:
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..
CERTIFIED EXPERT
Top Expert 2010

Commented:
Hi estecher,

This question is a duplicate of:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21797096.html

Regards,

Patrick
CERTIFIED EXPERT
Top Expert 2012

Commented:
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

Commented:
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?
CERTIFIED EXPERT
Top Expert 2012
Commented:
Please close this question, as you have now opened, in direct violation of the EE Guidelines a duplicate question here:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21801248.html

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
CERTIFIED EXPERT
Top Expert 2012

Commented:
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?
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi17
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.