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.

Thank you.

Neil

I am not sure if there is a more elegant way, but you can write a routine that reads the XML file a line at a time, and then types the data before it pushes it into the final table.

You may also want to push the XML file into Excel and then convert the column, and then pull the spreadsheet.

Need any help?

mmcdonal