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.
On Mon, 5 Jun 2006 07:43:01 -0700, Contracto
<Contracto[ at ]discussions.microsoft.com> wrote:
[Quoted Text] >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 [Microsoft Access MVP]
Please respond in the newgroup and not by email.
|