Copy Paste & Include other Data

JezLisle · #1 (**permalink**) 09-12-08, 09:53

I bring back data from a SQL Server database, and want to find out how I can include a word after the data I import is pasted into a cell.

This is my Code I have to paste the data record.

Code:

Sheet3.Range("C12").ClearContents
    Set rsDW = New ADODB.Recordset
    sQRY = "SELECT     MAX([Weeks Waiting]) AS MAX " & _
            "FROM jez.CYPPhyPaediatric "
    rsDW.CursorLocation = adUseClient
    rsDW.Open sQRY, cnnDW, adOpenDynamic, adLockOptimistic, adCmdText
    Application.ScreenUpdating = False
    Sheet3.Range("C12").CopyFromRecordset rsDW
    rsDW.Close
    Set rsDW = Nothing

What I want to do is in Cell C12 once it pastes the Number add Weeks after, so would look like 7 Weeks

How is that possible?

georgev · #2 (**permalink**) 09-12-08, 10:03

This would work...

Code:

SELECT Convert(varchar, Max([Weeks Waiting])) + ' weeks' As [max]

Other options include concatenating the word within Excel ala

Code:

Sheet3.Range("C12").Value = Sheet3.Range("C12").Value & " weeks"

JezLisle · #3 (**permalink**) 09-12-08, 11:11

Excellent Thanks