• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • Last Modified:

Getting error while uploading data to SQL Server 2000

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
dileepav
Asked:
dileepav
2 Solutions
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
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
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
dileepavAuthor Commented:
Thx Experts
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now