Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am bringing information from an Access recordset into Excel. I want
to start copying the recordset data starting with column two in the Access record. Column one is my primary key identifier and I don't want that. I'm thinking it has something to do with .Fields??? Below is my coding so far... 'Copy the matched recordset into the worksheet starting at column "AN" With wsSheet1 ..Cells(2, 40).CopyFromRecordset rs2.Fields(2,?????) <----unsure here End With 'Close connections with permit_life rs2.Close Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Start copying an access recordset starting with the next column | Excel Programming | |||
Code for getting Access recordset into Excel | Excel Programming | |||
Access Recordset Rows to Excel | Excel Programming | |||
Copy recordset from an Access "make table" query | Excel Programming | |||
Access Recordset with Built-In Function | Excel Programming |