Click here to Skip to main content
16,005,037 members
Home / Discussions / C#
   

C#

 
QuestionFinding COM-port information Pin
Tummelisa9-Jul-08 7:27
Tummelisa9-Jul-08 7:27 
Questionopening a from with reflection Pin
belzer9-Jul-08 6:09
belzer9-Jul-08 6:09 
AnswerRe: opening a from with reflection Pin
Christian Graus9-Jul-08 6:41
protectorChristian Graus9-Jul-08 6:41 
GeneralRe: opening a from with reflection Pin
belzer9-Jul-08 6:51
belzer9-Jul-08 6:51 
GeneralRe: opening a from with reflection Pin
led mike9-Jul-08 7:08
led mike9-Jul-08 7:08 
GeneralRe: opening a from with reflection Pin
Christian Graus9-Jul-08 7:19
protectorChristian Graus9-Jul-08 7:19 
GeneralRe: opening a from with reflection Pin
belzer9-Jul-08 7:29
belzer9-Jul-08 7:29 
QuestionReading an XLS sheet without ODBC? Pin
Xpnctoc9-Jul-08 5:59
Xpnctoc9-Jul-08 5:59 
Writing a project for a client using .NET 3.5 in C#. I need to import data from an XLS spreadsheet into a SQL data table. Problem is, one of the columns in the date table contains an "optional" date field. In the sample file provided by the client, no data exists in that optional field until row 27. The result is that NO ROW contains the optional field in the final SQL table.

I've been using an ODBC connection (MS Jet 4.0) to read the XLS. I tried adding MAXSCANROWS=0, which according to what I've read should allow the first 16384 rows to be used in determining column types. However, this seemed to have no effect.

I read another article that suggested the work-around is registry editing. That's not too practical, especially for deploying this project to the client's server.

Does anyone know another way to get the data to import correctly?

Thanks.
AnswerRe: Reading an XLS sheet without ODBC? Pin
Russell Jones9-Jul-08 6:28
Russell Jones9-Jul-08 6:28 
GeneralRe: Reading an XLS sheet without ODBC? Pin
Xpnctoc9-Jul-08 6:34
Xpnctoc9-Jul-08 6:34 
GeneralRe: Reading an XLS sheet without ODBC? Pin
Russell Jones9-Jul-08 6:38
Russell Jones9-Jul-08 6:38 
QuestionArrow in rowheader Pin
anton-099-Jul-08 5:39
anton-099-Jul-08 5:39 
AnswerRe: Arrow in rowheader Pin
paas9-Jul-08 6:42
paas9-Jul-08 6:42 
QuestionRe: Arrow in rowheader Pin
anton-099-Jul-08 6:51
anton-099-Jul-08 6:51 
AnswerRe: Arrow in rowheader Pin
PIEBALDconsult9-Jul-08 15:06
mvePIEBALDconsult9-Jul-08 15:06 
GeneralRe: Arrow in rowheader Pin
anton-0910-Jul-08 22:42
anton-0910-Jul-08 22:42 
AnswerRe: Arrow in rowheader Pin
anton-0911-Jul-08 18:00
anton-0911-Jul-08 18:00 
QuestionTab Control Pin
half-life9-Jul-08 4:44
half-life9-Jul-08 4:44 
AnswerRe: Tab Control Pin
User 66589-Jul-08 4:49
User 66589-Jul-08 4:49 
QuestionHow to create ".eml" file using desktop application in .net to use it to send E-mail? Pin
shababnet9-Jul-08 4:29
shababnet9-Jul-08 4:29 
AnswerRe: How to create ".eml" file using desktop application in .net to use it to send E-mail? Pin
Christian Graus9-Jul-08 4:36
protectorChristian Graus9-Jul-08 4:36 
GeneralRe: How to create ".eml" file using desktop application in .net to use it to send E-mail? Pin
User 66589-Jul-08 4:39
User 66589-Jul-08 4:39 
Questionhashtable within a hashtable Pin
benjamin yap9-Jul-08 4:02
benjamin yap9-Jul-08 4:02 
AnswerRe: hashtable within a hashtable Pin
Christian Graus9-Jul-08 4:07
protectorChristian Graus9-Jul-08 4:07 
GeneralRe: hashtable within a hashtable Pin
benjamin yap9-Jul-08 4:11
benjamin yap9-Jul-08 4:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.