Monday, January 16, 2012

MS SQL Import Truncation Error

I was having a problem importing an Excel spreadsheet into SQL Server that I just couldn't figure out.

After many attempts I decided to try importing into MS Access. It worked and it showed me where the errors are!

After fixing the errors I imported the Access table into SQL Server.

No comments:

Post a Comment

Thank you for commenting!