Importing an Excel Calendar vacation into Ms Access

[cstlaurent]

Hi

I am not use with VBA in Excel. I am trying to undrestand but not there yet. I am trying to facilitate capturing our vacation calendar in Access instead of building the tools completely in Access. I figure to write some code to look in a given selected area and return the name an the week where an X is place.

The vacation are kept in a Excel format such as:

Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Name1 x x x
Name2 x x
Name3 x x x

What I would like to have is this info send to an Access Table.

Tehcnician -- Week --
Name1 8
Name1 9
Name1 13
Name2 3
Name2 4
Name3 8
Name3 9
Name3 10

Hope you understand what I am looking for, Any help will be appreciate.

Thanks.