OleDb problem in excel

  • Thread starter Thread starter barry
  • Start date Start date
B

barry

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
 
I think there is no problem with the query, it does return the rows, but the
ine excel file top lines (headers) have about 3 to 4 lines in some cases.


Alvin Bruney said:
What do your queries look like?

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------




barry said:
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
 
Back
Top