View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default New user help and Excel read question (Interop and OleDb)

Check out this article:

http://support.microsoft.com/default...b;en-us;257819

about half way through see the discussion of this problem and using the IMEX
extended property.

--
Regards,
Tom Ogilvy


"sporadic" <sporadic.1q0gsy@ wrote in message
...

Well I'm able to convert the assumed data types on the fly after the
data set is filled and I'm pulling out values.
The problem now is that I'm getting empty values in fields where it has
assumed a data type and the field doesn't match correctly.

Is there a way to make the OleDb just blindly dump string values into a
data set with NO datatype guessing???


--
sporadicPosted from http://www.pcreview.co.uk/ newsgroup access