|
Home > Archive > MS Access Database with External Data > September 2005 > Date data not Text ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Date data not Text ?
|
|
| adrian 2005-09-20, 9:25 am |
| 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
| |
| KARL DEWEY 2005-09-20, 1:25 pm |
| 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.
"adrian" wrote:
> 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
>
>
>
>
|
|
|
|
|