Exporting Query From Access Into Excel

[ooch1]

Hello

I am wondering whether it is possible to run a query/macro in access and export the results into a specific sheet in an excel document. I'm sure it can be done, but i am a vba novice so will need some general guidance as to what the outline VBA code is.

OOch

 

[PHV]

Take a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ooch1]

Thanls PHV - I have now found the command in help and will have a go later, but no doubt i will run into dificulties so you may hear from me again soon!

OOCh

 

[xlbo]

I personally wouldn't use Transfer Spreadsheet as AFAIK, it is still stuck on the ~16000 row limit as per xl95 - won't work for > 16000 rows of data.

Have a look into DAO / ADO and the COPYFROMRECORDSET function

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[ooch1]

xlbo

I will take that advoce on board, although luckily i will not be transferring anything like that amount.

OOch

 

[xlbo]

lucky you !! in which case, go for the transfer spreadsheet method then - much easier !

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question