H
Howard
A MIS I am using exports tabular data as a csv file each night with
every field delimited with double quotes.
I need to link a table in my access database to this file to give an up
to date snapshot.
Problem is one of the fields represents a date (in long date UK format
e.g. 20 February 2008).
I have set the import specification under 'advanced' to say this field
is date/time but when I look at the table that field is filled with #Num!
I need it as a date for subsequent processing. How can I make it read it
as a date.
(I did get it to work by linking it all as text and then running a
Cdate() query on it but this is not the way I want to go)
Howard
every field delimited with double quotes.
I need to link a table in my access database to this file to give an up
to date snapshot.
Problem is one of the fields represents a date (in long date UK format
e.g. 20 February 2008).
I have set the import specification under 'advanced' to say this field
is date/time but when I look at the table that field is filled with #Num!
I need it as a date for subsequent processing. How can I make it read it
as a date.
(I did get it to work by linking it all as text and then running a
Cdate() query on it but this is not the way I want to go)
Howard