Get data from Excell - identify grouped rows

[DianePDavies]

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

Data in Excell 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)?

(I have posted this in the Excell group as well - but so far without any luck)

 

[Stefan Hoffmann]

hi,

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

As you don't need these structural information in Access:
Clone the sheet, remove the grouping and copy the data.


mfG
--> stefan <--

 

[DianePDavies]

...what does clone mean in this relation?

And I would like to know the grouping - as I want to load records as related
Access records with the group-header as a parent record and the rows in the
group as child records

 

[Stefan Hoffmann]

hi Diane,

..what does clone mean in this relation?

A copy of the worksheet.

And I would like to know the grouping - as I want to load records as related
Access records with the group-header as a parent record and the rows in the
group as child records

Take a look at the Outline property of your Worksheet object.


mfG
--> stefan <--