I am using the following code to run a Stored Procedure Query. It works perfect bringing back 4 columns of data. But is it possible to make it so that it only brings back 2 columns of data. I need the 2nd and 4th, which are named "DateOf" and "Gen", respectively. Someway to include a select command?
I posted here, without luck: http://www.mrexcel.com/forum/showthread.php?t=367809
Please Login or Register to view this content.
Last edited by erock24; 01-30-2009 at 06:36 PM.
I would just loop the recordset and copy only the data you want to the worksheet.
The code below would replace the CopyFromRecordset line. Change the worksheet index/name as required.
Please Login or Register to view this content.
Wow!! That seems to be working perfect. thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks