Import data from excel to sql server C# Application

Question

I'm using sql server 2008. I have a database "CustomerManagement", and a table "Customer" like this:

CustomerID    |    Name    |    Money
1             | Paul       | 300
2             | Mary       | 250
3             | David      | 
4             | May        | 
5             | Ann        |

And I have an excel file, with some data as the following:

CustomerID    |    Money
3             | 100
4             | 150
5             | 175

How I can insert "Money" in excel file to sql server based on CustomerID?

I'm using winform C# and MS Excel 2010

did you search SO or google? stackoverflow.com/questions/10750803/… — Asken
– Asken, Commented Nov 26, 2012 at 8:10
@Asken: yes, i did. But it tutorials insert data from excel to a new table. What I want is insert data to table with specified ID — furyfish
– furyfish, Commented Nov 26, 2012 at 8:15

andy · Accepted Answer · 2012-11-26 08:31:41Z

1

Retrieve all the data from Excel which you want to insert to sql Database and then loop it and insert to sql server.

Retrieve Data

Insert to SQL Database

edited Nov 26, 2012 at 8:31

answered Nov 26, 2012 at 8:24

andy

6,0792 gold badges29 silver badges50 bronze badges

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

Collectives™ on Stack Overflow

Import data from excel to sql server C# Application

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related