Changing Data Type from XML Import

[KrispyData]

When importing data from an XML file, all the data types are set to TEXT.
Design View does not allow me to change the text to another data type such as
date or number. Is there way to change this?

 

[Jeff Boyce]

A common way to handle this situation is to allow the XML file to be
imported as TEXT, and to create a more permanent table (or set of tables),
with the correct data types.

Then use queries to "parse" the raw import data into the final data types
and table structure you need.

Regards

Jeff Boyce
Microsoft Office/Access MVP