Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start copying an access recordset starting with the next column
I am bringing information from a recordset into Excel. I want to
start copying the recordset data starting with column two. Column one is my primary key identifier and I don't want that. I'm thinking it has something to do with .Fields??? 'Copy the matched recordset into the worksheet starting at column "AN" With wsSheet1 .Cells(2, 40).CopyFromRecordset rs2.Fields(2,?????) <---- this is where I am unsure End With 'Close connections with permit_life rs2.Close |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start copying an access recordset starting with the next column
Couldn't you just exclude the PK column from the select ?
Tim "gab1972" wrote in message ... I am bringing information from a recordset into Excel. I want to start copying the recordset data starting with column two. Column one is my primary key identifier and I don't want that. I'm thinking it has something to do with .Fields??? 'Copy the matched recordset into the worksheet starting at column "AN" With wsSheet1 .Cells(2, 40).CopyFromRecordset rs2.Fields(2,?????) <---- this is where I am unsure End With 'Close connections with permit_life rs2.Close |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code for getting Access recordset into Excel | Excel Programming | |||
copying a recordset into a variable | Excel Programming | |||
Excel VBA - Copying access column | Excel Programming | |||
Access Recordset Rows to Excel | Excel Programming | |||
Starting VBE at EXCEL Start | Excel Programming |