-
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
-
sorry i forgot this
note: it is offline plz dont include any server side script in your answer
-
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.
-
Senior Member
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
-
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.
-
Senior Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|