OleDb problem in excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "barry" <someone@xxxxxxxxxxxxx>
Date: Fri, 4 Apr 2008 15:27:09 +0530

Hi

I am using OleDbconnection / OleDbCommand to connect to excel file and
extract rows using Select ..., i find that OleDbDataReader return the rows
but only string data is there all numeric data returned is null, the no. of
fields returned is correct, does any know what could be the problem.

TIA
Barry

.

Follow-Ups:
- Re: OleDb problem in excel
  - From: Alvin Bruney [ASP.NET MVP]

Prev by Date: Deactivating Data Execution Prevention with NXCOMPAT
Next by Date: Re: Simple TCP Socket Communicator - Please Help
Previous by thread: Deactivating Data Execution Prevention with NXCOMPAT
Next by thread: Re: OleDb problem in excel
Index(es):
- Date
- Thread

Relevant Pages

Re: OleDb problem in excel
... [Shameless Author plug] ... The O.W.C. Black Book, 2nd Edition ... I am using OleDbconnection / OleDbCommand to connect to excel file and extract rows using Select ..., i find that OleDbDataReader return the rows but only string data is there all numeric data returned is null, the no. of fields returned is correct, does any know what could be the problem. ...
(microsoft.public.dotnet.framework)
Re: sqldatareader equivalent?
... If I have a oledbconnection and an sql statement string, ... Not sure what you mean here but you can use a standard sql statement coupled ... >> OleDbDataReader ...
(microsoft.public.dotnet.framework.adonet)