Importing queries from Access to Excel

Resolved · Urgent Priority · Version 2007

Thu 7 Apr 2011, 15:20 Delegate Sarah said...

Sarah has attended:
Excel Advanced course
Access Introduction course

Importing queries from Access to Excel

Hi
I have an access database with some queries set up, but when I try to import the queries to Excel using the From Access tool in the Data tab, I can't see my queries in the list. Some are there, and some not. Any ideas?
Thank you
Sarah

Fri 8 Apr 2011, 14:37 Trainer Mark said...

RE: Importing queries from Access to Excel

Hello Sarah,

Not entirely sure what your trying to achieve. If you have set up a query in Access, for example to display all the customers in London, then the results can be exported to excel from within the database in Access, which may be a better option.
To do this you must run the query you want to export, then go to the External Data Ribbon, in the Export section, Select Excel. Following the instructions in the dialog box.

Alternatively, the method your doing from within should work fine. Ive tried it several times and all queries show up. Sorry without seeing your setup I cannot answer why they do not appear in your list?

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Fri 15 Apr 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.