+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Database help needed in Technical; Hi A friend of mine has some software that no longer works but need the data held within it. I ...
  1. #1

    Join Date
    Mar 2007
    Posts
    207
    Thank Post
    24
    Thanked 4 Times in 3 Posts
    Rep Power
    15

    Database help needed

    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



    <InvoiceNumber>1</InvoiceNumber>
    <InvoiceAmount>5000</InvoiceAmount>
    <StockNumber>1</StockNumber>
    <UserInvoice>false</UserInvoice>
    <InvoiceDate>2008-02-06T00:00:00+00:00</InvoiceDate>

  2. #2


    Join Date
    Sep 2007
    Location
    UK
    Posts
    5,375
    Thank Post
    1,417
    Thanked 867 Times in 557 Posts
    Rep Power
    642
    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/ex...019641033.aspx

  3. Thanks to laserblazer from:

    cooper (13th August 2009)

SHARE:
+ Post New Thread

Similar Threads

  1. Database
    By silver_hippo in forum Courses and Training
    Replies: 2
    Last Post: 6th November 2008, 09:11 AM
  2. SIMS Database Size SHrinkDBLog Help Needed
    By Grommit in forum MIS Systems
    Replies: 13
    Last Post: 27th September 2007, 06:55 AM
  3. HELP!!!! - Database
    By lalalalalalalalalalala in forum How do you do....it?
    Replies: 1
    Last Post: 21st March 2007, 09:03 PM
  4. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  5. advice needed on weather a new server is needed
    By projector1 in forum Hardware
    Replies: 3
    Last Post: 24th February 2006, 09:20 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •