View Single Post
  #3 (permalink)  
Old June 12th, 2003, 12:19 PM
Graham Graham is offline
Registered User
 
Join Date: Jun 2003
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi

I've recently been moving Access MDBs into SQL 2k and hit the same error.

Turned out that SQL DTS was creating Access Date/Times as SmallDateTimes. In the end the only way I could fix this was to manually amend the tables in DTS then wrote a simple script to change all small dates to date times.

Regards
Graham
Reply With Quote