Import Log Problem

[mboe]

I am trying to import a windows 2000 event log. I used dumpel.exe to dump the event log into a comma delimited file. Everything looks fine. When I import into Access it always gives me an error on my time field. Eveything else imports fine. I even created a table first and formated the time field as per the format it is in in the text file (i.e. 8:00:00 AM). There does not seem to be any good reason it won't import properly.

 

[Fuga]

Have you checked the "advanced" tab in the import specification to see so that the field is set up as date?

Fuga.

 

[mboe]

Advance Date

Yes, that was one of the first things I checked. Of course it couldn't be that easy...