Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help with ADO and VBScript!
Hi expert, I have to say that I have no experience in VBscript before, I am a dat warehouse analyst and need to complete a report out of SQL Server. I need to have a little excel vbscript with ADO recordset code t change the first column, when it's starts with first letter 'D', then will have to replace the cell to a district manager name. First of all, I need to loop every row in column A only to find an cell with a 'D' prefixed word, for example, D1009. Then open a ADO connect to SQL Server and here is the SQL query: SELECT 'D' + CAST(District_Num AS char(5)) AS DISTRICT, DISTRICT_MGR FROM micros.Store_Table As long as I find the cell to match DISTRICT, then it needs to b replaced by DISTRICT_MGR Can someone show me the VBScript to complete this task? Thank you -- jenh ----------------------------------------------------------------------- jenhu's Profile: http://www.excelforum.com/member.php...fo&userid=2896 View this thread: http://www.excelforum.com/showthread.php?threadid=52550 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help with ADO and VBScript!
Why not do it in SQL Server using a Stored Procedure?
MH "jenhu" wrote in message ... Hi expert, I have to say that I have no experience in VBscript before, I am a data warehouse analyst and need to complete a report out of SQL Server. I need to have a little excel vbscript with ADO recordset code to change the first column, when it's starts with first letter 'D', then I will have to replace the cell to a district manager name. First of all, I need to loop every row in column A only to find any cell with a 'D' prefixed word, for example, D1009. Then open a ADO connect to SQL Server and here is the SQL query: SELECT 'D' + CAST(District_Num AS char(5)) AS DISTRICT, DISTRICT_MGR FROM micros.Store_Table As long as I find the cell to match DISTRICT, then it needs to be replaced by DISTRICT_MGR Can someone show me the VBScript to complete this task? Thank you. -- jenhu ------------------------------------------------------------------------ jenhu's Profile: http://www.excelforum.com/member.php...o&userid=28969 View this thread: http://www.excelforum.com/showthread...hreadid=525501 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run VBScript from Excel | Excel Discussion (Misc queries) | |||
Excel & VBScript | Excel Programming | |||
vbscript question... | Excel Programming | |||
VBscript | Excel Programming | |||
VBscript | Excel Programming |