Erro message during import of access DB...

Hello All!
I am getting an error whle I try to import an Access DB into a MSSQL DB.
Insert Error, ('DATEBIRTH', DBTYPE_DBTIMESTAMP), status 6; Data
Overflow. Invalid character value for cast specification.
Now, during the DTS wizard I tried changing the types to smalldate, or
just plain text but neither work.
any thoughts?
thanks!
LuisHi
Usually this is caused by incorrect data. You may want to load into a
staging table and make the date column char or validate the data before
loading.
http://groups-beta.google.com/group/comp.databases.ms-sqlserver/msg/c7514b83c7397d2c
John
"Anon" wrote:
> Hello All!
> I am getting an error whle I try to import an Access DB into a MSSQL DB.
> Insert Error, ('DATEBIRTH', DBTYPE_DBTIMESTAMP), status 6; Data
> Overflow. Invalid character value for cast specification.
> Now, during the DTS wizard I tried changing the types to smalldate, or
> just plain text but neither work.
> any thoughts?
> thanks!
> Luis
>|||hmmm. that stinks since we have almost 100k records in this table...mayb
eI can make some sort of update query to these records. Ok, thanks!
Luis
John Bell wrote:
> Hi
> Usually this is caused by incorrect data. You may want to load into a
> staging table and make the date column char or validate the data before
> loading.
> http://groups-beta.google.com/group/comp.databases.ms-sqlserver/msg/c7514b83c7397d2c
> John
> "Anon" wrote:
>
>>Hello All!
>>I am getting an error whle I try to import an Access DB into a MSSQL DB.
>>Insert Error, ('DATEBIRTH', DBTYPE_DBTIMESTAMP), status 6; Data
>>Overflow. Invalid character value for cast specification.
>>Now, during the DTS wizard I tried changing the types to smalldate, or
>>just plain text but neither work.
>>any thoughts?
>>thanks!
>>Luis|||Hi
It may highlight a deficiency in the current application, therefore any
clean up operation would have to be repeated each time you loaded your
SQL server database. Finding out why you have poor data would be
necessary to ensure a smoother transfer in the future. If you loaded
into staging tables your clean-up code could be used when transforming
that data into the live tables, this would mean you are not depending
on the current data source.
100K records is not actually that many, hopefully not all of them are
duff!!
John
Anon wrote:
> hmmm. that stinks since we have almost 100k records in this
table...mayb
> eI can make some sort of update query to these records. Ok, thanks!
> Luis
>
> John Bell wrote:
> > Hi
> >
> > Usually this is caused by incorrect data. You may want to load into
a
> > staging table and make the date column char or validate the data
before
> > loading.
> >
> >
http://groups-beta.google.com/group/comp.databases.ms-sqlserver/msg/c7514b83c7397d2c
> >
> > John
> >
> > "Anon" wrote:
> >
> >
> >>Hello All!
> >>I am getting an error whle I try to import an Access DB into a
MSSQL DB.
> >>
> >>Insert Error, ('DATEBIRTH', DBTYPE_DBTIMESTAMP), status 6; Data
> >>Overflow. Invalid character value for cast specification.
> >>
> >>Now, during the DTS wizard I tried changing the types to smalldate,
or
> >>just plain text but neither work.
> >>
> >>any thoughts?
> >>
> >>thanks!
> >>
> >>Luis
> >>