Excel to SQL server

[Ed Chiu]

Hi,

I am looking for ways to import multiple Excel files in a local hard drive
into SQL Server database. Can somebody give me some pointers?

I would prefer to do this in C# Windows Application, knowing that DTS can
probably give me what I want.

TIA

[Nicholas Paldino [.NET/C# MVP]]

Ed,

You can access DTS through C#, since DTS is exposed as a set of COM
components, you just have to set the references in your C# project to those
components.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Ed Chiu" <Ed****@discussions.microsoft.com> wrote in message
news:7A**********************************@microsof t.com...

Hi,

I am looking for ways to import multiple Excel files in a local hard drive
into SQL Server database. Can somebody give me some pointers?

I would prefer to do this in C# Windows Application, knowing that DTS can
probably give me what I want.

TIA