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.
>>
Jim Newsom
IT Director, ICG Inc.