Import Access Database info to Excel???

[jwr]

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]

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

 

[Dnereb]

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

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

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

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

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.

 

[jwr]

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.

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??

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?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.

 

[Dnereb]

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.