Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Fatalsniper
Starting Member
45 Posts |
 Posted - 2006-01-24 : 21:40:18
|
| Hey,I'm trying to import from access 2000 some tables to SQL Server 2000, and I run into a problem with date datatype, In access, the date field have some entries with some invalid dates like 01/01/2500, and I get somekind of overflow in any operation I try to do to fix this...is there a way to configure, or anything to bypass this error?...Thanks a lot!!! |
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2006-01-25 : 03:32:58
|
| What error are you getting? The DATETIME data type can contain dates up to 99991231, so it looks like you're using the SMALLDATETIME, right? If so, I would fix these invalid dates in Access before importing. Probably you can set them to 20790606, which is the max. value for a SMALLDATETIME column.--Frank KalisMicrosoft SQL Server MVPhttp://www.insidesql.deHeute schon gebloggt? http://www.insidesql.de/blogs |
 |
|
|
Fatalsniper
Starting Member
45 Posts |
Posted - 2006-01-26 : 22:18:43
|
| Thanks a bunch Frank it was all about converting smalldatetime to datetime, I set the date fields in access to that max and it worked fine!...Probably would be better to set somehow Sql Server, so when importing tables like this from access it will convert those to datetime instead of smalldatetime...Thanks again for your help!!! |
|
|
|
|
|
|
|
|
Overflow, access, date field