Hello world~!
I work on report system of the bank. My bank have many branches, so I have to collect many simple reports. Today I collect all reports using Excel tables as input data source and Access database as collecting system (for example: I collect rates of exchange, thay are different in each breanch. Then I calculate the averege rate of exchange). The Excel table of each branch is a same with only difference in rates and branches name (code). So when they send me Excel tables I can collect each row and calculate them all in Excel or Access. I prefer Access, because I need a history on each day.
So now I starting learn the InfoPath and trying to do the same reporting system in the XML + Access way. But for now I have some questions:
1. How can I access to the XML from MS Access, and how can I recognize the data using VBA?
2. Are there any standart data access protocols or VBA scripts?
3. May be I'm on a wrong way and you can direct me where can I read any same examples?
http://www.bank.com.ua