?
Solved

Getting error while uploading data to SQL Server 2000

Posted on 2011-03-14
3
Medium Priority
?
287 Views
Last Modified: 2012-05-11
Hi Experts,

PFA to see the details of the error that I get when I try to upload the data from an excel sheet to SQL Server table. Could you please help me in fixing this issue?

Please do get back to me, if you have any further query on this.

Thanks & regards
Dil.
SQL-Server-Error.JPG
0
Comment
Question by:dileepav
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 25

Accepted Solution

by:
DBAduck - Ben Miller earned 1000 total points
ID: 35133199
You need to look at the Line 107 to see what is in the row.  It is saying that the data in that row is too long to fit into the field buffer allocated (field length of the target).
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 1000 total points
ID: 35135310
Can you kindly check the datatype of tbl_field_description column in Excel and SQL Server..
Either trim that field in Row 107 (in Excel) to lesser size or increase the size of that column in SQL Server to get it work..
0
 

Author Closing Comment

by:dileepav
ID: 35292933
Thx Experts
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

752 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