If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing Data Type from XML Import
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? |
#2
|
|||
|
|||
Changing Data Type from XML Import
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 "KrispyData" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|