New user help and Excel read question (Interop and OleDb)
 

Well I'm able to convert the assumed data types on the fly after th
data set is filled and I'm pulling out values.
The problem now is that I'm getting empty values in fields where it ha
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
data set with NO datatype guessing??

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

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