Emulating DTS functionality with ADO Recordsets

[SBendBuckeye]

Hello,

I need to export some data into an Excel spreadsheet. I can do it very easily manually with DTS but the problem is that the client does not have access to any SQL Server stuff.

I am brand new to DTS but have used ADO quite a bit in the VB world to pull data into a recordset. How can I pull the Column Names out of SQL Server so I can incorporate them into my Excel VBA code?

Thanks in advance for any ideas, suggestions, tips, tricks, working code examples ;-), links, tutorials or whatever!

Have a great day!

j2consulting@yahoo.com