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.