.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.