.NET (Data Import )

I have a urgent question?

For Data import开发者_开发百科 from Source Excel to SQL Server Which is going to be one time import. which is the best way to do it .NET

---

Here is an article that you may find helpful.

Basically you access the file somewhat like you would a database. Some trial and error involved, but overall not too hard.

---

There are several ways:

1. For a simple one time import, just copy paste from excel straight into the management studio row editing screen. i.e. skip .Net entirely.

2. For a little more complicated, use management studio, right click on the database and say "import data"...

3. If it really must be a .net app, use ADO to open the excel file, read the records and write them to your SQL server.