Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

COPYING RESULTS OF FILTERED DATA

Status
Not open for further replies.
Kevsim

Kevsim

Instructor
Apr 18, 2000
385
AU
I have a query that has run and filtered the data. How can I now copy the filtered results of the query and import it to an excel spreadsheet. I wish to do this using visual basic. Your advise would be appreciated.
kevsim
 
Sort by date Sort by votes
Hi,

How about converting your current query to a 'Make Table' query then exporting the created table to Excel?

It's 2 clicks to convert the query.

It's simple, but if you want help on this then use Access help and search on 'make table query'.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Open filtered for and set cursor at particular record
Replies
1
Views
464
Moss100
Moss100
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
3K
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
751
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
560
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
784
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top