The_Player
asked on
Delphi 6 XML import into MySQL
Hi,
have a problem, I have created a connection to web service that sends me back offical current exchange rates. I get back the results that I have to import into a mySQL database, the resulting XML is attached to this question.
I have tried various approaches to import data, but all have failed. Is there something wrong with a response?!
Or I just didn't find the right solution? If so, what should I do?
I use Delphi 6 and mySQL 5. something.
Thnx,
The_Player
xml-response.txt
have a problem, I have created a connection to web service that sends me back offical current exchange rates. I get back the results that I have to import into a mySQL database, the resulting XML is attached to this question.
I have tried various approaches to import data, but all have failed. Is there something wrong with a response?!
Or I just didn't find the right solution? If so, what should I do?
I use Delphi 6 and mySQL 5. something.
Thnx,
The_Player
xml-response.txt
http://www.databasejournal.com/features/msaccess/article.php/3310901
ASKER
@dinilud:
Ok... So, what the article is telling me is that there is no easy way of importing data from XML into database and that I have to parse and "walk" XML tree myself? (I hope I didn't got it right :( )
If this is the case, is there at least any XML parser to create a tree from XML?
Ok... So, what the article is telling me is that there is no easy way of importing data from XML into database and that I have to parse and "walk" XML tree myself? (I hope I didn't got it right :( )
If this is the case, is there at least any XML parser to create a tree from XML?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks... :)
ASKER
Actually, when I continued the way you mentioned, I found this very useful guide: http://www.agnisoft.com/white_papers/SOAP1.asp :)
After doing a step by step procedure I had a convertor up and running in no time! :)
After doing a step by step procedure I had a convertor up and running in no time! :)