2007 Microsoft Office - Export from Access to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top