| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XML to Excel
We have an application using SQL. In one of the field in SQL table, it's XML
coding combining multiple fields. something like this -- <?xml version="1.0" encoding="ISO-8859-15"?<ItemInfo<row addr1 = "5100 Springfield Street, Suite 210" city = "Dayton" fname = "Emily" format = "" formattext = "" lname = "Abell" state = "OH" suffix = "" title1 = "Associate Software Engineer" title2 = "Adroit C4ISR Center" zip = "45431" /</ItemInfo How do convert this whole string into separate fields in Excel? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
| Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Threaded Mode
