Re: Fields with mixed string/number data

Peter A wrote:
In article <OqLzShIQHHA.4156@xxxxxxxxxxxxxxxxxxxx>, reb01501
@NOyahoo.SPAMcom says...
There was no way for you to know it (except maybe by browsing through
some of the previous questions in this newsgroup before posting
yours - always a recommended practice) , but this is a classic ADO
newsgroup. ADO.Net bears very little resemblance to classic ADO so,
while you may be lucky enough to find a dotnet-knowledgeable person
here who can answer your question, you can eliminate the luck factor
by posting your question to a group where those dotnet-knowledgeable
people hang out. I suggest microsoft.public.dotnet.framework.adonet.

Unfortunately, I've never used ADO or ADO.Net to retrieve spread***
data, so I cannot answer your question.


Thanks, I will look for an ADO.Net newsgroup. In the interim I found
the solution, to include IMEX=1 in the Extended Properties part of the
connection string. This tells the Jet engine to read all data as
strings.

Thanks for the follow-up. I hope I remember this.
--
Peter Aitken

--
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.


.