HELP PLEASE - Importing from Access

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




"jwr" <joyrose@bellsouth.net> wrote in message
news:3QULe.8296$xW.6022@bignews6.bellsouth.net...
>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
>
>

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
"Carl" <anonymous@cox.net> wrote in message
news:%aAMe.58441$DW1.42959@fed1read06...
> 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
>
>
>
>
> "jwr" <joyrose@bellsouth.net> wrote in message
> news:3QULe.8296$xW.6022@bignews6.bellsouth.net...
> >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 Frieds,

Recently I become member in Excelforum need some Tips, how perfectly handle this and get updates well!!!

Best Regards,
Rajeshkumar R