ETL and Data Integration tools - Modern ETL software for everyone

Hello

I am having terrible trouble importing date/time data via Visual Importer.

It doesn't matter what format I choose for the time, I am getting an error
message.

'' is not a valid date and time.

If I choose a standard date format then the values are imported (minus the
time). But the time element is critical.

The data source is a delimited text file that has been exported from an
Access Database.

Any help / guidance you can provide would be greatly appreciated.

Thanks,
Craig

Iportant thing to understand is that the date format is for source data not for the targer.

so if you source data looks like 01.12.2010 the format is dd.mm.yyyy
and for 1.1.2011 it is d.m.yyyy

Mike