Excel and Scientific Notation

[Paul]

Hi,

I got around Excel omitting certain cells when its type is
numeric by providing Extended Property IMEX=1.

Now the problem is the numeric values aren't really
numeric at all -- it's a symbol that happens to be
numeric. Excel is returning these symbols in scientific
notation and in some cases, rounding off the number,
making it impossible to recover the original symbol. How
can I tell the OleDb provider not to interpret certain
columns as numbers?

Thanks,
Paul

 

[Dino Chiesa [Microsoft]]

when I created the table via the Excel OLEDB provider,
and specified the type of the column, the data in the column was interpreted
correctly.

eg, something like

CREATE TABLE Extracto ( ProductId NUMBER, ProductName char(40),
QuantityPerUnit char(20), UnitPrice NUMBER, UnitsInStock NUMBER, Extracted
DATETIME )

Then if I subsequently add data through an app and the oledb provider, or
even manually through MS-Excel, and then later read that data, it was
interpreted properly.

I don't know how to do it otherwise.