I ran into this same problem myself over a few days, and
found out that this was an issue with my original Excel
spreadsheet data that translated into an Access 2000 data
formatting error.
My Problem: The date information was present in most
cells of my spreadsheet in a couple of columns, but other
columns rarely had any data in it at all. Therefore, when
importing the spreadsheet into Access, it recognized the
Date format from those Excel columns where it had quite a
bit of data, but ignored the formatting of those columns
where data was sparse. What I then got within the
database when looking at cells that should contain data
was an error message, and when I clicked on it I got a
more detailed error message about it being the wrong
format.
My Solution: I went into the Access Table that the data
was imported into in Design mode, and to the cells that
corresponded to the Date columns from Excel. I noticed
that in those problem cells, they assumed Text format
(probably due to the lack if information in those Excel
Date columns). I changed these manually to Date/Time and
applied the Short Date format, and voila! All of the data
appeared perfectly.
I'm not sure if this will help or not, but wanted to
offer what I'd ran into.
- Mike
