Faster way to copy a recordset in VBA

[Madhosh]

Hi,
I am trying to copy around 300 records from access to excel using sql. In my sql query, I am joining 2 tables and then copying the data from access.
I checked the run times and it seems that copy recordset function is taking a lot of time. Is there any way to increase the speed and optimize the code? I am also using
rs.Open sql, cn, adOpenForwardOn ly, adLockReadOnly (explicitly coping the records. Please suggest me a way.

[Rabbit]

We would need to see your code. It's hard for us to optimize code that we can't see. Please remember to use code tags when posting code per the forum FAQ.