help with table

[analytics2006]

I have a table set up like the following (updates by importing the excel file) and I am trying to set up a DTS package so it will automatically import the file on a daily basis since the file is being updated every hr. How can I code it so it will only automatically know which column represents current month and provide the data I need for current month. For example, in May should pull up custid 123 and 225 and only 285 in June. Is it possible to do it without manually going there to query against the current month column??

Thanks



productID jan feb march april may june custid

1 1 1 1 1 123
2 1 1 1 225
3 1 285