Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing queries from Access to Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Importing queries from Access to Excel

Resolved · Urgent Priority · Version 2007

Reply Thu 7 Apr 2011, 15:20Delegate 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

For upcoming training course dates see: Pricing & availability

Reply Fri 8 Apr 2011, 14:37Trainer 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.

Access articles

· Practice Microsoft Access Database Decorum To Reap The Rewards
· Protect Sensitive Access Databases With A Password
· So You Want To Create Forms In Access 2007?
· Be Top Of The Form With Access 2007
· The Three Classes of Databases

Please browse our web site to find out more about
access class microsoft training and other Microsoft training courses.

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips