Invisible wrote:

>>> So now I have a CSV file that contains the date, time, user, printer and
>>> page count. Just import that into Access and produce some stats, right?
>>>
>>> Wrong! Access apparently can't parse any of the dates. Despite them all
>>> being perfectly valid dates (and it even *detects* that this column
>>> should be a date column), it fails to parse every single last one. >_<
>> 
>> Have you tried importing your CSV file into Excel first, then moving it
>> to Access? I've found that it sometimes does better with external data.
>> It's an extra step, but it may give you cleaner data, and may make the
>> process easier to do the next time, if there is one.
> 
> I did notice that Excel apparently had no difficulty with the date
> column - or indeed any other column for that matter. So maybe that would
> work...

If all you have is Haskell, every problem starts looking like an erm... that 
self-functor (or whatever) thingy.

-- 
Stefan Viljoen

Post a reply to this message