Tables changing data type on the fly??

  • Thread starter Thread starter junk
  • Start date Start date
J

junk

I have a XML file that I import in which is a set format. I don't have
any ability to get the XML file setup changed. All fields are set up
to come into Access as text and do very successfully. However, there
are some of the fields I realy need to be a Number/Double format in
order to properly work with them. Is there any code that could be
written that would change to format of these fields right after import?
I would like to call something from a macro to change these formats.
Any ideas?

Thank you,
Neil
 
Hi Neil,

If it's a set format, how about creating the table in Access with Double
fields where needed (e.g. by importing the XML and changing the field types
manually). Then when you import, click the Options button in the Import XML
dialog and select Append Data to Existing Tables.
 
Back
Top