linking to csv file

  • Thread starter Thread starter TY
  • Start date Start date
T

TY

I linked a csv file which has date/time fields. When I
open the linked file in Access, the data in these fields
appear as "#Num!" What is wrong?
 
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).
 
Back
Top