I am having a problem importing into a DateTime field. The exported datetime data appears like this:

"1995-04-24-13.34.52.720000"

The VFP 5.0 import wizard ignores this field and the DateTime field ends up empty.

If I revise my import data to look like the following (no double-qoutes, colons separating the time instead of periods, and removal of the last time unit (720000), it works.

1995-04-24 13:37:03

Is there anyway I can use code instead of the wizard to import the data in the first format? If not, I'll have to edit all of my import data to match the second example (and I don't want that!).

Jeff Rusch
UW-Madison