|
![](/i/fill.gif) |
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
|
![](/i/fill.gif) |