data entry in excel by linking to other word doc. or excel sheets

[wangxuqin]

this sounds like using excel as a data recording tool question.

i have a client asking me this:

1. when he creates a new order either in word doc. (which he prefers
or in excel (he can accept using this too), how can I help him ente
the order in excel data sheet--he wants to include order number, orde
items (multiple usually), quantity etc.

2. when multiple orders are created in different files (e.g. one orde
is one unique .doc file), how can I help him update the data entry i
the excel spreadsheet by accessing newly created orders?

3. if one order has two or more order items, I hope i can enter th
data sheet with two or more rows (meaning that the data is stored a
order item level not just order level), how can i automatically creat
multiple rows for one order?

Sorry these questions sound very rudimentary...I try not to use ACCESS
and i do know how to use excel as a reporting tool once the data ar
entered.

thanks so much!

Jasmin

 

[Guest]

Do yourself a favor and avoid separate word docs LIKE THE PLAGUE.

You may not like Access, but using that is FAR preferable to the options
you've described.

This link has at least two versions of Access templates for customer orders

http://office.microsoft.com/en-us/templates/CT011366681033.aspx