HELP PLEASE - Importing from Access

  • Thread starter Thread starter jwr
  • Start date Start date
J

jwr

I previously posted a message but got no reply.

How do I get informI have NO idea how to accomplish this feat.

I have an access database. In this database, I have a very large query that
I need to export to excel.

1. Do I export from query, form or report?
2. Once in excel, I need all but 2 columns and then I will email to
customer.
3. Customer must enter info in those 2 columns and email back to me.
4. Once I get this information back, I would like for the info to flow
'back' to my access database.
5. The excel worksheet will be updated again when another action
occurs.
a. Can the access info be entered and update the excel info?

Please give me some direction with this. What I am asking may not be
possible.

My apologies, but I have never worked with access and excel.

Thanks in advance,
JR
 
Hi JR.
I used to do some reporting for BellSouth. (but I can't say from which
business partner.) Small world. How you want to do this is dependant apon
how often you will be doing it.
1) If Adhoc, cut and past results of query into Excel. Delete the columns
and send.
more often? Create a report and then file/export to Excel. don't get fancy
with the report.
2) Trim the excel to look like a table then link to it from Access. Run an
update query from Access to upload you rnew data.

That is one way
Second way :
Create the query in excel to pull from Access. Send for data input and then
update to access. (Acess needs to have a link to the file then update from
the linked Excel.)

Remember, you should test your theory and update queries on a test Db first.
hth
 
My experience with excel has been very limited. Simple worksheets. Can you
give me some direction/guidance as to how to create this query based upon
the access database?

This will be an on-going "report" and will be updated with criteria such as
"Between start and end date" and other criteria.

Thank you for your reply and assistance.
Joy
 
Back
Top