Hi TY,
CSV files don't have date/time fields, they have text fields that may or
may not contain strings that Access can interpret as date/time values.
The #Num! signal probably means that Access doesn't understand the way
date/time values are represented in your file. A good way round this is
to link these fields as text and then use calculated fields in a query
to convert the text values to Access date/time values (using functions
such as Instr() and Mid() to parse the text into year, month, day etc.
and DateSerial() to combine these into a date/time value).
