Forum Discussion
Dmitry_Nikolaev
Staff
13 years agoHi David,
This is the way in which the Data-Driven feature and DB Table variables work: they use an OLE DB provider from Microsoft to retrieve data.
If you do not like this approach, you are free to work with Excel using COM. This is a slightly more complex way of reading Excel sheets, but you will not have to care about field types. Information on this approach can be found in the Working With Excel Files via COM help topic.