[AccessD] Can't append all the records in the append query - set 1 field(s) to null due to type conversion failure

[Stuart McLachlan]

Ahem!  My turn :)

https://support.microsoft.com/en-us/office/using-the-date-time-extended-data-type-708c32d
a-a052-4cc2-9850-9851042e0024

The Date/Time Extended data type stores date and time information and is similar 
to the Date/Time data type, but it provides a larger date range, a higher fractional 
precision, and compatibility with the SQL Server datetime2 date type. When you 
import or link Access data to SQL Server, you can consistently map an Access 
Date/Time Extended field to a SQL Server datetime2 column.


-- 
Stuart

On 29 Jun 2022 at 6:53, Gustav Brock via AccessD wrote:

> Hi Paul
> 
> Access doesn't work very well with DateTime2, even though the newer
> versions have an option under settings to be "compatible" - but that
> does little, as DateTime2 in VBA is a no-no and probably ever will.
>