Error uploading records into a SQL Server table

Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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.
    68,430 pointsBadges:
    report
  • rbriggs
    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  
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following