Solved

Getting error while uploading data to SQL Server 2000

Posted on 2011-03-14
3
283 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 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Display SQL 2008 last modified/update Database 11 53
SQL - Curser to do an insert based on a select 2 26
ASP AND XML 3 30
sql server major issue  need help 2 49
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

726 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