That worked well, thank you again for the help.

>After loCon.Open() try:
>

>  loRS = loConn.Execute("select * from "+m.lcTemp)
>  With toSheet
>   FOR ix=1 TO loRS.Fields.Count
>     .Cells(1,m.ix).Value = PROPER(loRs.Fields(m.ix-1).Name)
>   endfor
>   .Range('A2').CopyFromRecordSet( loRS )
>  Endwith
>  loRS.Close
>

Cetin
>
>>Hi Cetin,
>>
>>I'm hoping you can help. I found your post in this thread while I was searching for a similar solution, and it has been working great. Now, though I am using the same approach and getting an error with a certain cursor, and I don't know enough about ADO to find the cause of the problem.
>>