View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DianePDavies DianePDavies is offline
external usenet poster
 
Posts: 7
Default Identify "parent rows" in a grouped structure

I am writing code to load data from Excel into an Access table.

Data is structured in a nested form with group headings and a number of rows
making up this particular group total.

When loading tha data I would like to identify all my rows of - say - "level
1" and then load the related records from level 2.

How do I identify the "level 1" and "level 2" rows through VBA (the object
model)?
--
Diane