column count?

[tractorvix]

Hi All,

I'm still trying to get my data normalisation to work correctly!
history is I'm using excel linked files that are set up as:
prod id Jan 08 Feb 08 Mar 08 etc
A 10 20 30
B 10 20 30

which I'm converting to:
Prod ID Date Value
A 1/1/8 10
A 1/2/8 20
A 1/3/8 30
B 1/1/8 10
B 1/2/8 20
B 1/3/8 30

the number of columns in the original table may increase over time and the current method of changing to the normalised table has a fixed value of x = 1 to 60
is there anyway to count the number of columns in the orginal table (currently 60) so that when additional columns are added it automatically increases?

Hope this makes sense!

Vicky

 

[Remou]

How about:

Currentdb.TableDefs("Table1").Fields.Count

 

[tractorvix]

Remou,

absolute genius mate.

Thanks

Vicky