how to develop interface between xml and mdb files

[PriteshP23]

Hello,

 

I would like to know how i can develop interface between XML and MDB files?

 

Actually, i need to convert files from XML into MDB and vice versa. Approximately, how much time it will take?

 

Thanks in advanced for your input.

 

[trq]

Approximately, how much time it will take?

That would completely depend on your ability, and the amount of differing data that you have.

 

How long is a piece of string?

[PriteshP23]

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.

[trq]

Do you have a specific issue?

[AbraCadaver]

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

[PriteshP23]

@AbraCadaver:

 

It sounds good. Thanks a lot.

 

Which one will be better ? Simplexml or DOMParser ?

[trq]

Which one will be better ? Simplexml or DOMParser ?/quote]

 

They do two different things.

[PriteshP23]

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

[AbraCadaver]

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.

[PriteshP23]

Thank you all for your input. I have got the basic idea for the project.