?
Solved

Getting error while uploading data to SQL Server 2000

Posted on 2011-03-14
3
Medium Priority
?
291 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 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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

840 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