P
Pow
Hi all,
Started a new summer job and I have been presented with the task of
taking an existing Access database and generating XML which will then be
transmitted and loaded into an offsite MySQL server. I have been given the
..xsd document (Russian Doll and Salami slice versions) and need to pull the
required data from Access and format it to the required schema provided. Not
sure how to go about this. As I see it there are a couple of options:
1 - Export all Access data to XML then convert to defined schema
2 - Select required Access data then create XML based on schema
Eventually I will need to automate this process so when a user adds a new
record to the existing Access DB, some XML is generated and uploaded to an
offsite server for addition to the MySQL DB.
Any thoughts on where to begin would be greatly appreciated! Including
good XML/Access reference books!
Thanks
Started a new summer job and I have been presented with the task of
taking an existing Access database and generating XML which will then be
transmitted and loaded into an offsite MySQL server. I have been given the
..xsd document (Russian Doll and Salami slice versions) and need to pull the
required data from Access and format it to the required schema provided. Not
sure how to go about this. As I see it there are a couple of options:
1 - Export all Access data to XML then convert to defined schema
2 - Select required Access data then create XML based on schema
Eventually I will need to automate this process so when a user adds a new
record to the existing Access DB, some XML is generated and uploaded to an
offsite server for addition to the MySQL DB.
Any thoughts on where to begin would be greatly appreciated! Including
good XML/Access reference books!
Thanks