Code to export Access records to Excel

[cloh]

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.

[nico5038]

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)