The given ColumnMapping does not match up with any column in the source or destination. I got this error... when i copy from excel to sql server.. Thanks...
2 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jeetendra GundPosted Oct 15, 2013, 6:39 AM
Yes they will match exactly, but i got the solution for that and problem is solved.
this error because of datatype mismatch with table datatype.
Thanks..
Jeetendra
Sunny SharmaPosted Oct 15, 2013, 1:04 AM
Make sure your excel column names exactly match that of database table column names and you'll be fine.
Cheers !!