Problem reading Excel files using OLEDB

From: masterslave <ocbka1@xxxxxxxxx>
Date: Wed, 16 Jan 2008 23:13:22 -0800 (PST)

Hi,

I'm reading writing out Excel files which are modified and then are
imported back in using OLEDB.

My problem is that I've got values coming in as junk like 7.5013e+006
instead of 7501301!! This
particular column is formatted as text because it can't be general as
I need leading zeroes...

Got a function to execute the query:
RunExcelQuery(file, String.Format("SELECT * FROM [{0}$]",
worksheetname), New OleDbParameter() {}, hasHeader)

Here's my connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\ExcelPricelists
\ZZZ_20080116.xls;Extended Properties="Excel 8.0;IMEX=1;HDR=NO"

.

Follow-Ups:
- Re: Problem reading Excel files using OLEDB
  - From: Paul Clement

Prev by Date: RE: 64-bit SQLOLEDB connection failure
Next by Date: (0x80040E31) Timeout expired
Previous by thread: RE: 64-bit SQLOLEDB connection failure
Next by thread: Re: Problem reading Excel files using OLEDB
Index(es):
- Date
- Thread