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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
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
Click to expand...

--
Bob Heifler
My Access Program, Owner
www.myaccessprogram.com
info (At) MyAccessProgram (Dot) com

Message posted via AccessMonster.com
 
Back
Top