Jump to content

how to develop interface between xml and mdb files

Go to solution Solved by PriteshP23,

Recommended Posts

I have 50 Mb MDB file and 20 Mb XML file. I just need to know functional flow and tools/technical issues.


I hope i am clear to you.

From XML to Access:

1. Read xml with simplexml and store in vars

2. Connect to mdb with odbc functions or PDO odbc

3. Insert records using vars


From Access to XML:

1. Connect to mdb with odbc functions or PDO odbc

2. Run query and get records and store in vars

3. Write out XML with simplexml using vars

Link to comment
Share on other sites

I think to read XML file only. Which one i should choose ?


You need to evaluate the complexity of your XML and project in general.  SimpleXML is "simple" and somewhat limited.  DOM implements the W3C DOM API, differentiates between element and attribute nodes and allows you to use PHP functions in XPath queries.


So DOM might be a good choice.  Start with that as it will give you more control.

Edited by AbraCadaver
Link to comment
Share on other sites

This thread is more than a year old. Are you sure you have something important to add to it?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.