Updating one table from another sql server
The dates that you can convert depend on the size of the number field.
Remember that Access stores all dates as serial dates, and it stores the date values as double-precision floating integers. Dates outside the range April 18, 1899 and September 11, 1900 exceed the size of a Byte field.
If you try to run an action query and it seems like nothing occurs, check the Access status bar for the following message: This action or event has been blocked by Disabled Mode.
By default, Access disables all action queries (update, append, delete, or make table queries) unless your database is in a trusted location or the database is signed and trusted.
As a result, some of the data in the destination fields may be truncated (deleted).
As you continue, remember that although the data types for each table field do not have to match, they must be compatible.
Access must be able to convert the data in the source table into a type that the destination table can use.
The section Restrictions on data type conversions lists the ways in which you can and cannot convert data types.
The table in this section also explains when converting a data type can change or eliminate some or all the data in a field, and what data might be eliminated.