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.
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.
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Thank you for commenting!