cooper Posted August 12, 2009 Posted August 12, 2009 Hi A friend of mine has some software that no longer works but need the data held within it. I have a file with the xml database but need to extract this in a readable order. Here is a sample of some of the data below, there are a few more lines then it repeats. I would like to open this in excel with column 1 invoice number, column 2 invoice amount column 3 stock number ect... Can and how can this be sorted? Thanks 1 5000 1 false 2008-02-06T00:00:00+00:00
laserblazer Posted August 12, 2009 Posted August 12, 2009 Excel should be able to open the xml file and then you can insert the headers yourself if Excel doesn't do it for you. This might help http://office.microsoft.com/en-us/excel/HA011019641033.aspx 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now