Date data not Text ?

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#Num! Error in Link to Excel 1
Dates from DB2 displaying as 12:00:00 AM 3
Separating carriage return data into separate cells 2
Three fields to represent a date? 5
Date Format Question Again 2
exporting date fields to excel 1
How can I stop date formatting? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top