Re: InfoPath with Excel and Access = Report system?

Patrick Halstead — Tue, 02 Aug 2005 07:17:36 GMT

Hi Panda and welcome to our forum!
1. You can create a data source for tables in your Access database. Go to Forms->DataConnections->Add->Retrieve, etc. Or do this when you first design a form.
2. It uses ADO.NET.
3. Lots of samples in the InfoPath SDK.

Patrick Halstead [InfoPath MVP]
InfoPathDev

InfoPath with Excel and Access = Report system?

Panda — Mon, 01 Aug 2005 13:07:13 GMT

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

General

Re: InfoPath with Excel and Access = Report system?

InfoPath with Excel and Access = Report system?