Identify "parent rows" in a grouped structure

D

DianePDavies

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)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get data from Excell - identify grouped rows 3
Problem using group function with hidden rows 0
Navigating Indentured BOMs (Parts Lists) in Excel 1
Sorting a spreadsheet that is grouped/outlined 2
Group rows based on indention of string in a column 0
"Add/Remove Rows Code" adds rows on grouped sheets, but won't remove rows. 1
Macro for hiding/unhiding a set of rows 3
Group / collapse rows 2

Top