converting acess database to xml and putting xml file into oracle

[omerdurdu]

I have a question about xml files to oracle via coldfusion
I have an xml file, created from access database. I wold like to write some code and put the this xml file into Oracle database. Can someone give me an idea about that
Thanks,

 

[Sarky78]

what version of CF are you using?

if you are using MX then i am lead to believe that you are able to query an xml document (haven't had chance to try this yet)

so all you would have to do is to set up a datasource to the oracle database, query the xml document and then insert the various information into the data structure of your oracle database.

if i can verify that this querying of xml is possible i'll post some code up that might/should help you

 

[omerdurdu]

Thanks for your reply.
What I would like to do: I have several xml files
coming from text file. I mean i converted these text files into xml. And they are under c:\xml directory.
Those xml files has data in it for the oracle database.
i was thinking I can read these files with CFFILE and then
problem starts here I am not sure what kind of code I can use. IF statements or is there any other coding method to inset these data into oracle database.
thanks