DATE/TIME

[Guest]

I am linking an excel spreadsheet with a new database table. The spreadsheet
has a number of consecutive date fields (ie. Delivery 1, Delivery 2, etc).
When I link the first field is correct, but subsequent fields change to
"text" fields in the database. Is there any way of stopping this?

Regards

 

[John Nurick]

The most likely cause is that some of the values in the worksheet that
look like dates are in fact text. One way to check this is by using the
Excel ISTEXT() function in formulas referring to the cells in question.