Importing from Excel

[Marie]

Hi,

I'm trying to perform an operation where I can email employees a form
created in excel, and when the form is filled out and emailed back to me,
when I save it, it will automatically update my database with the
information filled in the form by the employees. For example, if I send a
form with a list of office supplies and the employee needs to fill in
quatities of supplies needed, when I get the form back and save it, it will
update my database with the quantities of supply items, name of employee
placing the order, and their department. I would appreciate any answers
anyone can give me. Thanks.

Marie

 

[John Vinson]

Hi,

I'm trying to perform an operation where I can email employees a form
created in excel, and when the form is filled out and emailed back to me,
when I save it, it will automatically update my database with the
information filled in the form by the employees. For example, if I send a
form with a list of office supplies and the employee needs to fill in
quatities of supplies needed, when I get the form back and save it, it will
update my database with the quantities of supply items, name of employee
placing the order, and their department. I would appreciate any answers
anyone can give me. Thanks.

Marie

You should be able to use File... Get External Data... Link to link to
the returned Excel workbook, and then run an Append query from that
linked spreadsheet into your table (or, possibly, an Update query to
update existing records).

If you have specific problems doing so, please post back with the
details.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[John Vinson]

Hi,

I'm trying to perform an operation where I can email employees a form
created in excel, and when the form is filled out and emailed back to me,
when I save it, it will automatically update my database with the
information filled in the form by the employees. For example, if I send a
form with a list of office supplies and the employee needs to fill in
quatities of supplies needed, when I get the form back and save it, it will
update my database with the quantities of supply items, name of employee
placing the order, and their department. I would appreciate any answers
anyone can give me. Thanks.

Marie

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps