RE: [Microsofts_C_Sharp] Excel

Wed, 19 Jan 2005 16:18:14 -0800

Title: Message

But I have to do this programmatically in my C# code… I have tried it with ADO.Net and the connectinostring, but that does not work. Maybe I’m doing something wrong, so that’s why I asked for help. Maybe someone has some code in C# which does this, So he can send that to help me.

 

Thanx

 

From: Stephen Russell [mailto:[EMAIL PROTECTED]
Sent: woensdag 19 januari 2005 23:58
To: [email protected]
Subject: RE: [Microsofts_C_Sharp] Excel

 

DTS = Data Transformation Services in SqlServer speak.

 

Open up the EM and it's the folder under DataBases.  It allows you to bring in/out data.  It's great for bulk loads from outside systems.  I get an updated price sheet that is 52 workbooks.  I can create a different DTS line for each WorkBook. 

 

 

Stephen Russell
S.R. & Associates
Memphis, TN 38115

901.246-0159

-----Original Message-----
From: Koen Willemse [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 19, 2005 3:54 PM
To: [email protected]
Subject: RE: [Microsofts_C_Sharp] Excel

Could you explain a bit more about that, cause I don’t know what a DTS is……

 

From: Stephen Russell [mailto:[EMAIL PROTECTED]
Sent: woensdag 19 januari 2005 22:00
To: [email protected]
Subject: RE: [Microsofts_C_Sharp] Excel

 

I found it easy to go from Excel to SQL Server via a DTS.

 

 

Stephen Russell
S.R. & Associates
Memphis, TN 38115

901.246-0159

-----Original Message-----
From: Koen Willemse [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 16, 2005 3:11 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [email protected]; [EMAIL PROTECTED]
Subject: [Microsofts_C_Sharp] Excel

Hi everybody,

 

Does anybody know how to import/export data from/to MS Excel using ASP.NET and C#? I’m not very familiar with it, but I have to do this in the app I’m making. It would be great if someone has an example for me. I want the peoplewho use the app to give a filename, so that the app can import or export data to this file. Anybody who can help? I think I saw something about an connectionstring for Excel? Is it possible to do it with that, so that I can get the data in a dataset and that I can export data from a datatable to an excel file? I sure hope you can help me…

 

Thanx already!

 

Koen

 

P.S.

If somebody has a class or something that already does this, it would be great if you could send me this, so I can use this!

 


Yahoo! Groups Links

Reply via email to