Excell data input form that links to/inserts data to Access Databa

M

Matthew

We have a Job Database (400 entries right now) that contains all manner of
info for jobs.

What I would like to know is if there is a way to make an Excell(03/07)
Input form that links to the DB (Access 07) and inputs the data in the
appropriate location. For instance so that a Project Manager can submit info
on a new job without having to actually get into the database (very scary
thought lol).

I am not a Pro at Access, nor Excell per-say. I know my way around both
fairly well though.

Thanks in advance
 
H

heifler via AccessMonster.com

If your Excel data entry people do not have access to where your Access data
is, for example, they might be physically away. You can use regular email to
feed Access the data. Two ways, Outlook coding or Access 2007 email form
importing.

I would be happy to help.
See my Signature - No charge for contact questions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top