Problem importing data from a table in Access database

Hi,
I needed to import an Access database to sql server 2000. However, in one
table, the table definition got created but could not import the data. I
tried importing the data again, however, I am getting the following message:
Error at Destination for the row number 251. Errors encountered so far in
the task: 1/
Insert row error, column 5('AuditStartDate', DBTYPE_DBTIMESTAMP), status 6:
Data overflow. Invalid character value for cast specification.
The AuditStartDate column in Sql Server is currently having a datatype
smalldatetime with a length 4 while in the Access database the AuditStartDate
is Date/Time datatype with mm/dd/yyyy data e.g. 07/01/1992.
I appreciate any help on this. Thanks.ALTER TABLE ALTER COLUMN on the destination table and modify the data type to
DATETIME. This should give you a bigger range.
Sincerely,
Anthony Thomas
"Jack" wrote:
> Hi,
> I needed to import an Access database to sql server 2000. However, in one
> table, the table definition got created but could not import the data. I
> tried importing the data again, however, I am getting the following message:
> Error at Destination for the row number 251. Errors encountered so far in
> the task: 1/
> Insert row error, column 5('AuditStartDate', DBTYPE_DBTIMESTAMP), status 6:
> Data overflow. Invalid character value for cast specification.
> The AuditStartDate column in Sql Server is currently having a datatype
> smalldatetime with a length 4 while in the Access database the AuditStartDate
> is Date/Time datatype with mm/dd/yyyy data e.g. 07/01/1992.
> I appreciate any help on this. Thanks.