Thanks for looking Jeff. Actually, I created a macro in Excel to get the
Pivot Table and then, at the end of the macro, I did a copy/paste special to
get just the numbers (in Pivot Table format, but without the 'Pivot Table'
Anyway, I think I got a handle on it now. I had some blank rows in another
spreadsheet that I imported, and I guess something got lost during the
Transferspreadsheet process from Excel to Access. As I understand it, Access
doesn't like lots of blank rows. I used an Excel macro to delete all blank
rows. Also, in the Access Table, I changed the Data Type to Number and Field
Size was changed to Currency. Finally, in the Excel sheets, I converted
everything to Number format. Even though there is some text in there,
EVERYTHING on the Excel sheet is formatted as a number. The text always
imported fine...those numbers were importing correct for the most part, but
some were pretty screwed up. Finally, for anyone who someday encounters a
similar issue, and sees this post, make sure you have only numbers in a
column or only text in a column. In Column C, for instance, don't have this
in Excel: 23, 25, 34, fourty-nine, 56, 31. That was NOT my problem, but
during my research of this problem, I found this listed as a good idea of
what NOT to do.
Hope that helps others...