>I am accessing a remote data table that is set up kinda strange
>
>It has five rows representing manufacturing days. Each row has a year column and twelve month columns.
>
>In each month column there is a string representing each day of the corresponding month like JAN 2009 would be
>HNNN-----NN-----NN-----NNNNNNNNm
>
>Feb 2009
>N-----NN-----NN-----NN-----Nmmmm
>
>I need an array that has four elements
>Year
>Month
>Day of Month
>Value(H,N,-,m)
Instead of an array, wouldn't a cursor be easier to manipulate?
In any case, you will have to write the loop to go through the data, and create the array rows, or cursor rows.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)