Solved

Getting error while uploading data to SQL Server 2000

Posted on 2011-03-14
3
279 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
3 Comments
 
LVL 24

Accepted Solution

by:
DBAduck - Ben Miller earned 250 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 250 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

Suggested Solutions

Title # Comments Views Activity
Scheduled IIS .Net2 AppPools recycle and SQL connection Hangs 33 91
Merge Statement 3 40
Help with simplifying SQL 6 51
Ssis not sending failure message 2 10
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

867 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

24 Experts available now in Live!

Get 1:1 Help Now