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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Better option for getting data from an MS Access file? 6
Memory leak when using OleDb 6
OleDbDataReader and TEXT field 1
Excel with Ado.Net and OLEDB problem - 1
login/password C# and access. 9
Using parameters in a SQL OleDb provider leads to "must declare variable error" 1
Excel OLEDB reading Chinese characters unicode problem 1
ACE 64 bit 1

Back
Top