423,688 Members | 1,889 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,688 IT Pros & Developers. It's quick & easy.

Export Access Table to Excel

P: 38
Hello friends

I have extracted 30 numbers of Query Based Table. It is time taking to export these tables to excel one by one. Please help me to create a Macro, VBA Code, or Command Button which export all my tables in One Click.

Thanks
Irshad Ahmed
Jul 28 '18 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,285
irsmalik,

Welcome to bytes.com

Please read the FAQ - you'll see that we're here to help you with your code, not to write the code for you.

If you will kindly do a search on this site, you will find many examples showing exactly how to do what you are asking - just go to the top of this page, in the search box next to the orange magnifying glass enter you search terms
Access, Excel, Export Query

Here's the link to one such search ( :) )

If you have large memo fields then you may want to review this insight article
home > topics > microsoft access / vba > insights > exporting filtered access datasheet to excel spreadsheet - no truncation

Given that you already have a stored query, there are the built in methods: Open your query, then in the ribbon external data tab > export > excel enter the location, select the options and see if this works.

If this doesn't work then VBA has a few tricks up its sleeves that we can point you to ranging from the canned docmd.SendObject to Application.Excel automation - there are several examples here on Bytes.com that you can find with a simple search - find something close and we're happy to help modify it WITH you.

Happy to help, but you need to take the first steps.
Jul 28 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.