>> 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...

Post a reply to this message