Home > IT Answers > SQL Server > Error uploading records into a SQL Server table
SQL Server Ask the Experts
2,585 pts.
 Error uploading records into a SQL Server table
SQL Server errors, SQL Server tables
We have 700 hundred records, and we wish to upload them into a SQL Server table. After 600 have been uploaded, SQL Server failed to upload the last 100. Why might this have happened?

Software/Hardware used:
ASKED: January 21, 2009  6:07 PM
UPDATED: January 22, 2009  1:51 AM
RELATED QUESTIONS
Answer Wiki:
It could be any number of things. The database or disk could be full. There is a value in the data being uploaded which doesn't fit into the table. What ever process you are using to import the data can't parse the file correctly for some reason. Without more information about the method being used to import the data, and the error message you received not much usefull information isgoing to be able to be provided.
Last Wiki Answer Submitted:  January 22, 2009  1:51 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I think you will need to specify how are you uploading those records, and what error message you are getting.
The SQL server version could be useful as well.

carlosdl
 63,535 pts.
 

I would recommend using ‘Excel to database ‘ as the utility will validate the data before it is uploaded, and report any problems to you immediately.It could save you a great deal of time.You read about and download the utility here:http://leansoftware.net/en-us/products/exceltodatabase.aspx  

rbriggs
 30 pts.