By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,654 Members | 1,811 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,654 IT Pros & Developers. It's quick & easy.

Code to export Access records to Excel

P: 41
I have a problem, and I don't really know where to start.

I have a SQL query in Access that gives me a large recordset. I would like to "transfer" the entire recordset to a worksheet in Excel. Is this possible? I would like the format to be exactly the same as the SQL query. Could someone please point me in the right direction? Thanks in advance.
Oct 9 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
You can copy/paste the result of a query into excel, but some formats might be cripled and there's a max of some 65.000 rows in excel...
Just press the little grey square top left or press CTRL+A to select all and use CTRL+C and CTRL+V for the copy/paste.

Personally I prefer to have the data in a table and use the right-click options to filter and sort the data.


Nic;o)
Oct 10 '07 #2

Post your reply

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