| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ado add an id variable to a table
Hello,
I'm creating a recordset with the following (partial) code: rs1 = MainTableRangeSheet & "$" & MainTableRangeNoDollar & "]" Sql = "SELECT * FROM " & rs1 & " AS T1 objRecordset.Open Sql, ObjConnection, adOpenForwardOnly The code works fine... I'm interested at adding a unique ID variable to each record (1,2,3...) Could you help? Thanks Avi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| two-way variable table keeps repeating same value | Excel Worksheet Functions | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| one variable data table | Excel Worksheet Functions | |||
| having a table name be a variable | Excel Discussion (Misc queries) | |||
| Pivot Table - Object variable or with block variable not set? | Excel Programming | |||
Threaded Mode
