Validation of Data before uploading of excel to sql db

Joined
Jan 19, 2012
Messages
3
Reaction score
0
I want to upload excel data to sql db using SQLBulkcopy?But, I want to perform some validation checks on data.How can I check datatype of a cell as integer.If not then how to show it Error Report.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,920
Messages
2,570,038
Members
46,449
Latest member
onedumbsquirrel

Latest Threads

Top