simple qu: xml and access or excel database

[rasha ali]

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

[rasha ali]

sorry i forgot this

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

[rasha ali]

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.

[tupps]

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

[rasha ali]

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.

[tupps]

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