Non-numeric character in datetime or interval 1

[lesc]

I am attempting to populate a table with data extracted from a MSACCESS db. I have been unable to resolve the following error that I am getting when issuing the "DBLOAD" command:

*********************************
In INSERT statement number 1 of raw data file Event.txt.
Row number 101 is bad.
512|510|7| | |B #252| |09-15-2004 08:00:00|09-15-2004 08:00:00|06-23-2004 10:13:
|8|1|06-23-2004 10:13:48|0|1|16|1|1

Non-numeric character in datetime or interval.
*********************************

All of my datetime fields are formatted month to second. I have checked the number of columns to make sure that they are correct. I have also verified that MSACCESS didn't do something funky with the order of the data during export.

Any help would be much appreciated.

Thank you,
Les

 

[olded]

Les:

I understand your datetimes are defined month to second, but your data reads:

09-15-2004 08:00

which is a format that Informix will not understand. If your datetime was year to seecond, the format would be:

2004-09-15 08:00:00

Although I haven't tested it, I would think a month to second format would look like:

09 08:00:00

Regards,


Ed