Gustav Brock
Gustav at cactus.dk
Sun Apr 1 07:10:23 CDT 2007
Hi John That is strange - or it may be a limitation in the upsize wizard - as #12:00:00 AM# is a perfectly valid date value in Access. /gustav >>> jwcolby at colbyconsulting.com 01-04-2007 13:54 >>> In fact my question was more simple than that. I have values in the date fields that are #12:00:00 AM# for example. Those values are NOT valid in SQL Server, or at least will not upsize correctly. I had to find and fix all such values by adding some date to them to make them #1/1/1800 12:00:00 AM#. Once I did that, the table with such fields would upsize. John W. Colby Colby Consulting www.ColbyConsulting.com