How to create an Excel template and archive responses to an Access '97 file

[Mayda Acosta]

Hi,

I'm looking for some help on how to do this.

I have an existing database that we use to log some
accounts payable data.

The clerk keys in the data she reads from a hard copy form
that looks like the access form.

We would like to find out if there is a way to create an
electronic form (in Excel or Word) that she could use to
feed the access database almost automatically once she
receives the forms by Email.

Is there anybody kind enought out there that can provide
me some example or general direction on how to do this.

Your help will be deeply appreciated.


Mayda Acosta

..

 

[Michel Walsh]

Hi,


Instead of a e-mail (even if XML encoded) , I would ask my correspondent to
log to a web page which would have access to a database (FrontPage, as
example, allow you to relatively easily build such a page), it is probably
easier to further work on the data, already in a db.


Hoping it may help,
Vanderghast, Access MVP