build database based on xml schema

[traymar]

Dear members,



I have a xml schema which defines all things necessary (tables, field names, relationships, etc) to build a database in access. The question is whether Access could decode xml schema and build the database (create all tables, fields and relationships) automatically by macro or something else. I have tried to load xml schema by using external data in Access. However Access can only recognize some tables, not everything. Please let me know if you have any solutions. Thanks.

Regards,


Billy

[R_Badger]

I don't know much about xml, however I did a quick Google search and found this:

http://support.microsoft.com/kb/285329

Is that applicable to you?

[orange]

I have seen other posts where certain attribute info caused xml to be "not workable" when importing with Access.

However, I also found this via Google - you can see if it's applicable to your situation.
http://technet.microsoft.com/en-us/l.../ee692914.aspx

I recall someone saying you could import xml to excel, then possibly import from excel to Access. I don't have experience with this.