Convert string to date/time MS Access will accept at import

[Thomas Andersson]

I have my data collector script finished now and it works fine. Now my
problem is that MS Access throws a hissyfit when I try to import my data. At
first I thought it was the AutoNumber field that caused it but it isn't as I
found the report saying that I get "Type Conversion Failure" on every filed
containing time info.

All my collected data have the time info stored in this format "Jul 28
18:34" (Tab delimitered) and now I guess I need to convert all those on the
fly before they are stored to something Access will accept.

Is there any (hopefully easy) way to do this?

Best Wishes
Thomas

 

[Martijn Lievaart]

I have my data collector script finished now and it works fine. Now my
problem is that MS Access throws a hissyfit when I try to import my
data. At first I thought it was the AutoNumber field that caused it but
it isn't as I found the report saying that I get "Type Conversion
Failure" on every filed containing time info.

All my collected data have the time info stored in this format "Jul 28
18:34" (Tab delimitered) and now I guess I need to convert all those on
the fly before they are stored to something Access will accept.

Not really a Perl question, but an Access one. Fortunately, been there,
done that.

The only way to get Access to reliably parse datetimes, is to offer them
as YYYY-MM-DD HH:MM:SS. I think you can leave of the seconds.

Note that this is still assumed to be in the current timezone, you'll
neet to STFG if this is a problem for you.

HTH,
M4