<div>
in sql convert dates to a string in the format yyyy-mm-dd. In sql this format always works fine. Also, check between smalldatetime and datetime data types in sql server.
</div>


<div>
It was data related with some very silly dates in the table. &nbsp;Feel pretty silly TBH!
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I'm moving an Access database to SQL using the Wizard. &nbsp;All the tables convert OK apart from two. &nbsp;I've discovered it is related to date fields - if I copy the tables, remove all the date fields and then try it works fine.<br />
<br />
I've tried migrating just the table structure and using an append query but this errors with an &quot;Overflow&quot; message. &nbsp;Again if I do the same with the date fields removed it works.<br />
<br />
Can anyone suggest a solution for this.<br />
<br />
Thanks<br />
<br />
<br />

</div>
</div>


Hello,

I'm moving an Access database to SQL using the Wizard.  All the tables convert OK apart from two.  I've discovered it is related to date fields - if I copy the tables, remove all the date fields and then try it works fine.

I've tried migrating just the table structure and using an append query but this errors with an "Overflow" message.  Again if I do the same with the date fields removed it works.

Can anyone suggest a solution for this.

Thanks




in sql convert dates to a string in the format yyyy-mm-dd. In sql this format always works fine. Also, check between smalldatetime and datetime data types in sql server.

It was data related with some very silly dates in the table.  Feel pretty silly TBH!

Append from Access to SQL failing on date fields.

Hello,

I&#39;m moving an Access database to SQL using the Wizard.  All the tables convert OK apart from two.  I&#39;ve discovered it is related to date fields - if I copy the tables, remove all the date fields and then try it works fine.

I&#39;ve tried migrating just the table structure and using an append query but this errors with an &quot;Overflow&quot; message.  Again if I do the same with the date fields removed it works.

Can anyone suggest a solution for this.

Thanks




Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.