reading excel worksheet

[amitguitarplayer]

Hi Guys,
I am trying to read an excell worksheet from vb.net.. everything runs ok... but when it reads the column "METER" which has value as 2640101 \ 2124607
it returns nothing... my query looks like
SELECT * FROM TableM

but whenever it comes across values like 2640101 \ 2124607
OR 2540058 \ 2640428 etc.. it will return blank ! ?

PLEASE HELP !!!!!

Amit

 

[MattP]

I tried this using Jet for an .xls file and ACE using an .xlsx file and the got values.

What does your connection string look like?