Access query to excel and back to access updated??

's Computer Specifications

I have been reading the posts regarding converting/linking access to excel,
and it all seems so simple. However, I am completely lost!

I have a query in access that I need to export or just email in .xls format
to end users. (The query is based upon 2 tables.)They in turn should fill
in the data requested (2-3 columns) and email back to me.

1. How do I get the info from Outlook to excel?
a. Do I just "save as" in a file folder in excel?
2. Once I have the info emailed back to me, how do I update the access
query.?

I am using Access 2003 and Excel 2002.

Thank you

I have searched through access help and excel help, and for some reason, I
cannot seem to understand that to do. This is my first attempt (actually
the same attempt numerous numerous times) to no avail.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to check data from excel list against access query and return value back to excel	Dreamkeeper	Microsoft Access	0	31st Oct 2007 07:27 PM
Macro to check data from excel list against access query and return value back to excel	dreamkeeper	Microsoft Excel Discussion	0	31st Oct 2007 07:27 PM
Macro to check data from excel list against access query and return value back to excel	dreamkeeper	Microsoft Excel Worksheet Functions	0	31st Oct 2007 07:26 PM
Macro to check data from excel list against access query and return value back to excel	dreamkeeper	Microsoft Excel Programming	0	31st Oct 2007 07:26 PM
Link query to Excel, then back to Access??	=?Utf-8?B?bnlyYmx1ZTI=?=	Microsoft Access External Data	1	24th Jul 2007 10:59 PM