Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

DTS error - Import from Excel - 'too large for specified b..

 
   Database Forums (Home) -> DTS RSS
Next:  Literature Review Access 2007 template  
Author Message
Augustin Prasanna

External


Since: Jun 13, 2008
Posts: 3



(Msg. 1) Posted: Tue Oct 28, 2008 9:52 pm
Post subject: DTS error - Import from Excel - 'too large for specified buffer si
Archived from groups: microsoft>public>sqlserver>dts (more info?)

When we try to import data from an excel, we are getting an error 'data for
source column <column name> is too large for the specified buffer size'.

We tried copying a large value for this particular column in the first 8
rows and it works. But we need a better solution where we need not manipulate
the excel file manually.


Thanks in Advance.

Regards,
Augustin

 >> Stay informed about: DTS error - Import from Excel - 'too large for specified b.. 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> DTS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]