Import Access Database info to Excel???

I 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

"jwr" <joyrose@bellsouth.net> wrote in message
news:U_vLe.15827$rp.13100@bignews1.bellsouth.net...
> I 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
>
>

Originally Posted by jwr

1. Do I export from query, form or report?

You can opt to export to Excel from Access or the other way around Import Access data into Excel in this case I would prefer the latter.
In your VBA IDE set the reference to the highest availble DAO (3.6 I hope)
Open the Query in design mode and delete the fields you do not want
(temoprary just don't save)
Copy the SQL(SQL view in design mode) of your Query
place it in a/some strings(s)

Open a DAO database
Open a recordset based on the query You've copied
loop through the record set and copy the fields to the cells you want
Mailt the worksheet

Originally Posted by jwr

3. Customer must enter info in those 2 columns and email back to me.

This has to be detected in OUTLOOK I doubt if outlook express supports VBA

Originally Posted by jwr

4. Once I get this information back, I would like for the info to flow
'back' to my access database.

Again use DOA to connect to your database

Originally Posted by jwr

5. The excel worksheet will be updated again when another action
occurs.
a. Can the access info be entered and update the excel info?

Yes but it would be easiet to open the excel workbook from outlook and update the stuff

Originally Posted by jwr

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

BTW this is quite a big task to do with no experience. It is possible but getting someone to do it freelance is probably better.

Yes this is a big task, but I am going to attempt to tackle it! Thank you
for replying.

A few more questions please.
See below your comments.

"Dnereb" <Dnereb.1tuyqb_1124197520.5248@excelforum-nospam.com> wrote in
message news:Dnereb.1tuyqb_1124197520.5248@excelforum-nospam.com...
>
> jwr Wrote:
> > 1. Do I export from query, form or report?You can opt to export to
Excel from Access or the other way around
> Import Access data into Excel in this case I would prefer the latter.
> In your VBA IDE set the reference to the highest availble DAO (3.6 I
> hope)
> Open the Query in design mode and delete the fields you do not want
> (temoprary just don't save)
> Copy the SQL(SQL view in design mode) of your Query
> place it in a/some strings(s)
> What do you mean - "place it in a/some strings(s)"?
> Open a DAO database
> Open a recordset based on the query You've copied
> loop through the record set and copy the fields to the cells you want
> Mailt the worksheet
Mailt??
> jwr Wrote:
> > 3. Customer must enter info in those 2 columns and email back to me.
This has to be detected in OUTLOOK I doubt if outlook express supports
> VBA
Wouldn't this be the same as emailing an excel worksheet?
> jwr Wrote:
> > 4. Once I get this information back, I would like for the info to flow
> > 'back' to my access database.Again use DOA to connect to your database
> jwr Wrote:
> > 5. The excel worksheet will be updated again when another action
> > occurs.
> > a. Can the access info be entered and update the excel info?Yes but it
would be easiet to open the excel workbook from outlook and
> update the stuff
Less key punching is my goal. This leaves less room for error.

> jwr Wrote:
> > 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,
> > JRBTW this is quite a big task to do with no experience. It is possible
> but getting someone to do it freelance is probably better.
>
>
> --
> Dnereb
> ------------------------------------------------------------------------
> Dnereb's Profile:
http://www.excelforum.com/member.php...o&userid=26182
> View this thread: http://www.excelforum.com/showthread...hreadid=395613
>

Do you see the diffrence between your and my post?
I find it hard to read yours you can use the Quote button to format quotes.
I'm not ordering you to do so, but it will enhance the response for sure.

Mailt = Mail with a t typt on error. (if you like to point out every type and spelling error consider this: I'm not a native english speaker)
and Easiet = Easier if you want to know.

1)You don't export from the query or anything else directly, but you can the SQL from the Query to retrieve the information you want. You need to make a DAO connection to the database file.

3) to catch the return mail you need outlook to detect it. You can send an e-mail from excell with the worksheet, because you can not send an e-mail to Excel.


If I've left out some Question just repeat it. I find it hard to detect what you wrote. so maybe you could post these without a quote.