I try to export a table from Access 2007 to SQL-Server Express 2008R2 and it returns the error:
ODBC call failed.
[Microsoft][SQL Server Native Client 1.0][SQL Sever] Line1: Specifed Scale 1 is invalid (#1002).
The problem is related with a datetime column, because if I drop this column it is possible to export.
Thanks for your help.
View Complete Post