dcsimg
A Flash Developer Resource Site

Results 1 to 6 of 6

Thread: simple qu: xml and access or excel database

  1. #1
    Senior Member
    Join Date
    Mar 2002
    Posts
    160

    Arrow

    hello everybody,

    can anyone help me, i need to link xml to access or excel database (of coarse to call it from flash at last) , but actually i dont know how, thanks in advance

  2. #2
    Senior Member
    Join Date
    Mar 2002
    Posts
    160
    sorry i forgot this

    note: it is offline plz dont include any server side script in your answer



  3. #3
    Senior Member
    Join Date
    Mar 2002
    Posts
    160
    ok, may be my qu isnt clear enough here is exactly what i am trying to do :

    i want to make a flash movie that is used offline, and this movie has a huge array of data that is used inside the movie (names of employee their id and...), and i want to link my flash movie to an access or excel table instead of writing this array inside the code, to make editing more easy, but i dont want to use any server side script no asp , cgi, php, perl,.......at all , i just wanna use xml and the excel or access table making the xml call the table and flash calls the xml ,, can this happen???,, and how???
    hope i have made it more clear.


  4. #4
    Senior Member tupps's Avatar
    Join Date
    Jan 2001
    Location
    Melbourne
    Posts
    2,035
    What you will need is a script that exports your access or excel to XML.

    Then flash can read the XML file and get the data that it needs.

    Thanks

    Luke

  5. #5
    Senior Member
    Join Date
    Mar 2002
    Posts
    160
    thanks,
    u mean xml script , yes?? and if yes
    can u tell me plz where i can find a tutorial to learn about this script or can u help me with it.

  6. #6
    Senior Member tupps's Avatar
    Join Date
    Jan 2001
    Location
    Melbourne
    Posts
    2,035
    XML is not a scripting language. It is a format for data to be respresented in.

    What you will need is some VBA script or a script in Access basic that will export the data into XML.

    Eg you have data that looks like this (in access/exel etc):

    Name, Address, State, Suburb
    Bill, 27 Smith St, Vic, South Melbourne
    Bob, 29 Bob St, Vic, Richmond

    You need a script to turn it into:

    < MyData>
    < Person>
    < Name>Bill< /Name>
    < Address>27 Smith St< /Address>
    < State>Vic< /State>
    < Suburb>South Melbourne< /Suburb>
    < /Person>
    < Person>
    < Name>Bob< /Name>
    < Address>29 Bob St< /Address>
    < State>Vic< /State>
    < Suburb>Richmond< /Suburb>
    < /Person>
    < /MyData>

    You need to get a script or export the data in a format like that. You will have to search the web for scripts like that. Or find yourself someone who can do VBA, shouldn't take more than an hour or two for basic data.

    Thanks

    Luke



Posting Permissions

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




Click Here to Expand Forum to Full Width

HTML5 Development Center