Re: Why ADO with Excel formats text data with only numbers ?
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Thu, 29 Jun 2006 08:54:53 -0400
Sorry, I've no direct experience doing this. The only knowledge I have
came from that google search. Have you tried googling for your error
message?
Perhaps the adonet group can provide more assistance.
JoseValencia wrote:
Hi Bob, thanks but it didn't work when I use the CAST function I gethttp://groups.google.com/group/comp.databases.ms-sqlserver/browse_frm/thread/1678755b6673b51a/72f03347c3c0dbd9?lnk=st&q=%22Excel+8.0%3BIMEX%3D1%3B%22+number+as+text&rnum=8&hl=en#72f03347c3c0dbd9
an exception:
IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
Any help?
"Bob Barrows [MVP]" wrote:
JoseValencia wrote:
I'm using ADO.NET to read an excel file. In one of the columns IWill this help?
have data that can be a mix of numbers and letters, but sometimes
there are only numbers. The value I get for the number 300015532 is
3.00016e+008. I want to capture the actual value 300015532 .
Anybody has fixed it?
Here is the connection string used in the datasource:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\file.xls;Extended
Properties="Excel 8.0;IMEX=1;"
Here is a sample of values of such column:
300014AKB
300014AKQ
3000152TQ
300014AGY
300015532 --> This failed
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- References:
- Re: Why ADO with Excel formats text data with only numbers ?
- From: Bob Barrows [MVP]
- Re: Why ADO with Excel formats text data with only numbers ?
- Prev by Date: SaveToFile error
- Next by Date: Re: Here's a rather broad question...
- Previous by thread: Re: Why ADO with Excel formats text data with only numbers ?
- Next by thread: SaveToFile error
- Index(es):
Relevant Pages
|
|
