Last post Jun 12, 2007 04:09 AM by TATWORTH
Feb 14, 2007 06:58 AM|lard|LINK
Im trying (and failing) to get information from an excel spread sheet to be used in some form of calendar. Since its a case of 365ish bits of information each, as well as several columns of data (so 6 columns of 365 rows of data), Im having no luck.
If anyone can point me in the right direction just to read the data, would be so helpful.Thing is Im very very very new to ASP.net so anything more that basic explainations and crayon drawings, if thats ok
Feb 14, 2007 07:31 AM|TATWORTH|LINK
Try importing the spreadsheet into SQL Server using DTS with SQL200 or SqlServer Integration Services with SQL2005.
Feb 14, 2007 10:21 AM|lard|LINK
Feb 18, 2007 12:17 PM|TATWORTH|LINK
Jun 12, 2007 04:09 AM|TATWORTH|LINK
For users of SQL 2005 Express there is a useful import/export utility at http://www.codeproject.com/aspnet/ImportExportCSV.asp (A Simplified SQL-CSV Import/Export Functionality)