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