Exporting database to excel

[jwrnana]

I need to email info; therefore, I need to export to excel in a format that
will be maintained without manually manipulating the size of the cells,
totaling columns. I attempted to import from excel the access database
query. I am not getting all of the database imported. I used MS Access
driver.mdb. I can see some of my tables and queries, but others read
MSsys.queries.

Can you suggest a way to do this, either in access or excel?

Thanks in advance.
JR

 

[jwrnana]

I have an Order Entry database. Once an order is shipped, I need to forward
all of the following: customer info, order info, ship to info, product
info, order date, invoice date, ship date. I have a query that contains all
of this information and it works fine in access; however, I cannot email the
query (or can I) on, some may have access, others not. Thus, I need to
either export from access to excel -- or import access database query to
excel.

Going from access to excel, the information flows through, but the format is
"jumbled." I have to decrease size of rows and columns to make it legible.
Then I need to protect some of the columns as the end user is to input
information into several columns of the worksheet and email back to me. I
then must bring that information "back" to access.

As you can see, I really do not know which way to go with this. When I
import database query to excel, I do not see all of my queries - in
particular the one that I am needing. I was thinking a template would be
the answer - again, no experience with either way.

Thanks for your prompt response and willingness to assist.

JR

 

[jwrnana]

Many many thanks.
JR

OK, I think I see what you need. Just a little brain storming I am
thinking about populating and existing spread sheet. Maybe some of the
settings you need could be formatted in advance or maybe you could develop
an Excel macro to do the formatting after you import the data.

If I get time, I will play with the idea.

BTW I believe the answer for your problems is on the Excel side, not
Access as I don't think Access is going to be able to send the formatting
information.