Using SQL Bulk Copy to fill a database table

Question

I'm working on an web app using ASP.NET MVC4. I have an Excel file with several columns (some of them are useless) and I'd like to export the data to a related table by uploading the file.

One of my superiors told me to use SQL Bulk Copy to do that. I search some information about that but nothing really interesting (for example, nothing about how to map the excel columns and the table fields).

Any idea/tutorial to do that?

@RameezAhmedSayad => To be honest I'm following the instructions I received. — Traffy
– Traffy, Commented Jul 18, 2013 at 8:24

Tejas Vaishnav · Accepted Answer · 2013-07-18 10:41:06Z

1

Hello friend please review this article, i think it will contains all the required information you needed. but you need to do some modification as per your requirement.

SQLBulk insert from Excel

if you are facing any connection issue with your Excel workbook, please modified your excel connection string for that there is a good article provide all the necessary information regarding Excel connection string Excel Connection String Sample

answered Jul 18, 2013 at 10:41

Tejas Vaishnav

4586 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using SQL Bulk Copy to fill a database table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related