| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I import XML as text format
I'm trying to use a map in Excel to import XML data but I get errors saying
'Some data was imported as text'. These errors occur then I have numbers prefixed with zeros e.g. 0052, is there any way of either getting all of the data imported as text format e.g. "0052" or being able to choose how the field is imported or formatted? Regards, Huw Jenkins. |
|
#2
|
|||
|
|||
|
You can use TextConverter. I am not sure what format XML file you are working with, but you can submit it and get the project set up to perform the import.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format numbers in chart datatable | Charts and Charting in Excel | |||
| How do I rotate a text box | Charts and Charting in Excel | |||
| Text Cuts Off | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
| import csv file | Excel Discussion (Misc queries) | |||
Linear Mode
