Query on MS Excel Rows and Columns
Posted on 2011-10-31
I didn't really know how to title this quiestion so I am hoping someone stumbles across it and can assist.
What I have is an excel spread sheet.
Column Heading is a date period, i.e. 10/1/11, 10/8/11, 10/15/11...ect
Rows are Item numbers ie. part# 12345, 34685, 58647, ect
and the field is usage quantity.
Can someone suggest how I import this into Access and use this informatioin to query for differences in the field numbers where part number and date period match?
I'm just drawing a blank as to how I might do this.