What I mean with:
> So I changed the definition in SQL Server from SmallDatetime to DateTime and the import succeeds.
Is that I changed the datatype of the 'EndDate' Column in the table design of the table where the import fails (by means of the SQL Enterprise Mgr). You can also use the...
Hello Millzy,
I had the same problem with valid dates (2099-12-31). The Import Export Wizard in SQL Server automatically creates a table when the table does not exist when importing.
In Access (my source) the datetime field is created in SQL Server (my destination) as a SmallDatetime field...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.