joining multidate pointfile to shapefile grid

Discussion created by aubie on Jun 16, 2010
I've got a point file that is a 71 x 32 grid with data for 4 days that I would like to spatially join to a shapefile grid.  The problem is when I try to perform the spatial join, only the point file data corresponding to the 1st day is joined to the shapefile.  the data for the remaining 3 days is not joined.

I know I could seperate the pointfile into 4 separate files and do the join, but this is a test for a larger task that will require joining pointfiles containing daily data for entire years, so I would like to figure out a way to do it automatically.

I've attached the files below.  Thanks in advance for any assistance.