Hi, I guess this would be off topic but in PHP u have an entire PEAR PACKAGE for this saw it today on http://www.pear.org/
On Thu, 20 Jan 2005 13:13:54 -0600, Stephen Russell <[EMAIL PROTECTED]> wrote: > > Connection string aside you have to TWEAK your registry settings for ODBC > connections for Excel. Excel SUCKS in it's default setting for ODBC. Just > a heads up on that. I wasted a day with it before I found out about the > depth that it examines a column and all. > > the chances of you getting NULL values instead of real data are very good. > > http://support.microsoft.com/kb/306572/EN-US/ > > > > > Stephen Russell > S.R. & Associates > Memphis, TN 38115 > > 901.246-0159 > > > -----Original Message----- > From: Koen Willemse [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 19, 2005 6:18 PM > To: [email protected] > Subject: RE: [Microsofts_C_Sharp] Excel > > > > > 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 > > To visit your group on the web, go to: > http://groups.yahoo.com/group/Microsofts_C_Sharp/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. -- '*-~.,_,.~-*'`'*-~.,_,.~-*'`'*-~.,_,.~-*'`'*-~.,_,.~-*'`'*-~.,_,.~-*'`'*-~ Linker - You cant do without it... ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Microsofts_C_Sharp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
