Date data not Text ?

  • Thread starter Thread starter adrian
  • Start date Start date
A

adrian

Hi,

I am linking an Excel worksheet to my MS Access database.


Excel Table

Name ExpiryDate
*******************
Adrian 31-10-2007
Peter 99-99-9999


Access Table

Name ExpiryDate
*******************
Adrian #Num!
Peter 99-99-9999

The data type for the ExpiryDate in Access is reported to be Text. But it
reported a #Num! error while importing 31-10-2007. Why is 31-10-2007 not
text?
Thanks for any help rendered.


Regards,
Adrian
 
I always put a phony record as the first row under the column names and put
text in the columns to insure it will import as text.
 
Back
Top