Hi

I ran this query on sql 2012 and got the error below,

A severe error occurred on the current command. The results, if any, should be discarded.

Regards

Rohit

HI

In order to load from Excel into SQL Server, you should have Bulk_admin database role rights on your ID with Insert permission on database.

you can use the below script to...