Click here to Skip to main content
15,886,137 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionhow to View text file Pin
netJP12L14-Jan-09 6:15
netJP12L14-Jan-09 6:15 
AnswerRe: how to View text file Pin
ToddHileHoffer14-Jan-09 7:11
ToddHileHoffer14-Jan-09 7:11 
GeneralRe: how to View text file Pin
netJP12L14-Jan-09 7:30
netJP12L14-Jan-09 7:30 
GeneralRe: how to View text file Pin
ToddHileHoffer14-Jan-09 7:44
ToddHileHoffer14-Jan-09 7:44 
GeneralRe: how to View text file Pin
N a v a n e e t h14-Jan-09 15:59
N a v a n e e t h14-Jan-09 15:59 
AnswerRe: how to View text file Pin
MitchellBaldwin14-Jan-09 7:18
MitchellBaldwin14-Jan-09 7:18 
QuestionReading Excel Data Pin
Bharathy Sadagopan14-Jan-09 5:53
Bharathy Sadagopan14-Jan-09 5:53 
AnswerRe: Reading Excel Data Pin
pmarfleet14-Jan-09 11:10
pmarfleet14-Jan-09 11:10 
It sounds like this is an issue with the Excel driver attempting to guess the data type for the column. The driver has probably made the decision, based on sampling an initial number of rows (default is 8) that the column should contain text values. Values that look like they belong to another data type will be disregarded and show up as NULL. If you add the element 'IMEX=1' to your connection string this tells the driver to treat intermixed data in a column as text (see here[^])

If you need to increase the number of rows that the driver uses to guess the data type for a column, you need to make a registry change. See this article[^] for more information.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush


GeneralRe: Reading Excel Data Pin
Bharathy Sadagopan15-Jan-09 5:08
Bharathy Sadagopan15-Jan-09 5:08 
QuestionASP.NET Dynamic Data Pin
gantww14-Jan-09 5:42
gantww14-Jan-09 5:42 
QuestionDispose a datatable Pin
Member 236391614-Jan-09 4:48
Member 236391614-Jan-09 4:48 
AnswerRe: Dispose a datatable Pin
Aman Bhullar14-Jan-09 4:54
Aman Bhullar14-Jan-09 4:54 
GeneralRe: Dispose a datatable Pin
Christian Graus14-Jan-09 5:12
protectorChristian Graus14-Jan-09 5:12 
QuestionHow to use group by in datatable in c#? Pin
Member 236391614-Jan-09 3:04
Member 236391614-Jan-09 3:04 
QuestionAccess to bin folder denied because of forms authentication Pin
oceanexplorer8214-Jan-09 2:40
oceanexplorer8214-Jan-09 2:40 
Questionradio button binding Pin
cooltoad12314-Jan-09 2:26
cooltoad12314-Jan-09 2:26 
AnswerRe: radio button binding Pin
_AK_14-Jan-09 2:31
_AK_14-Jan-09 2:31 
GeneralRe: radio button binding Pin
cooltoad12314-Jan-09 2:33
cooltoad12314-Jan-09 2:33 
GeneralRe: radio button binding Pin
_AK_14-Jan-09 2:41
_AK_14-Jan-09 2:41 
QuestionHow can I make my asp.net 2.0 web application display exactly the same in firefox as in IE? Pin
Nada Adel14-Jan-09 2:20
Nada Adel14-Jan-09 2:20 
AnswerRe: How can I make my asp.net 2.0 web application display exactly the same in firefox as in IE? Pin
Christian Graus14-Jan-09 2:21
protectorChristian Graus14-Jan-09 2:21 
AnswerRe: How can I make my asp.net 2.0 web application display exactly the same in firefox as in IE? Pin
oceanexplorer8214-Jan-09 2:35
oceanexplorer8214-Jan-09 2:35 
AnswerRe: How can I make my asp.net 2.0 web application display exactly the same in firefox as in IE? Pin
Boro_Bob14-Jan-09 2:55
Boro_Bob14-Jan-09 2:55 
GeneralRe: How can I make my asp.net 2.0 web application display exactly the same in firefox as in IE? Pin
Nada Adel14-Jan-09 3:27
Nada Adel14-Jan-09 3:27 
GeneralRe: How can I make my asp.net 2.0 web application display exactly the same in firefox as in IE? Pin
oceanexplorer8214-Jan-09 3:52
oceanexplorer8214-Jan-09 3:52 

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.