I have a XML data file I receive that comes into Access 2003. All the fields are defined as Text, however, there are two fields that need to be Number/Double. There is no way I am going to be able to have the XML file changed. Is there some way through VB
code to change the data type on this table on the fly through calling the code in a macro? I don't want to have to stop and change the data types manually.