Data Import Problems

Hi
Not sure which newgroup to place this question. Hope someone here can help m
e.
I am using the Data Import on an SQL Srv2000 to import data from an Access
2003 database. All works well except 2 tables with Date/Time formats I get
data overflow errors? Other tables with Date/Time are importing fine
suggestions ?
Regards
MeirHi
What is a date format in Access's table?
If you have problems , you may try to define SQL Server's table as
VARCHAR(n) then import the data and later by using CONVERT function to
convert these values to the "right" format as YYYYMMDD
"mrrcomp" <mrrcomp@.discussions.microsoft.com> wrote in message
news:056CDAA3-E637-48B5-9D48-CB80597D1789@.microsoft.com...
> Hi
> Not sure which newgroup to place this question. Hope someone here can help
> me.
> I am using the Data Import on an SQL Srv2000 to import data from an Access
> 2003 database. All works well except 2 tables with Date/Time formats I get
> data overflow errors? Other tables with Date/Time are importing fine
> suggestions ?
> Regards
> Meir
>