2007 Microsoft Office - Export from Access to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mino - 29 May 2007 12:29 GMT

I have several querries in Access (for example, "Name and Account", "Name and
Address", "Name and Degree"...) and all those querries' data is from a table
named "Students".

Before with 2005 Access and Excel, I can export each query into the same
Excel file. But now after installing 2007 Access and Excel, I can export one
query only, for example, I can only export query "Name and Account". And when
I tried to export the other query "Name and Address", I couldn't because the
querries ( "Name and Address", "Name and Degree"...) are disappeared from the
query's list.

I think may be those querries' data are from the same table; therefore once
you export a query meanning the data has been used, you cannot use or export
them again.

Does anybody have any idea how? I appreciate any help I can get. Thanks.

Reply to this Message

Mino - 29 May 2007 13:46 GMT

Never mind. I found the way to import from Access to Excel. Here they are in
case someone wants to know:

Click Data.
Click "From Other Source" (instead of clicking "From Access" that what I did
before)
Click Microsoft query
Click MS Access Database
Chose your query

> I have several querries in Access (for example, "Name and Account", "Name and
> Address", "Name and Degree"...) and all those querries' data is from a table
[quoted text clipped - 12 lines]
>
> Does anybody have any idea how? I appreciate any help I can get. Thanks.

Reply to this Message