March 12, 2002 at 9:37 am
I am getting an error importing with DTS a Date/time format from access 2000 into a SQL 7 table. The error states
"Error at destintion for Row 63 Errors incountered so far in this task: 1 Insert error, column 7 ("Date", DBTYPE_DBTIMESTAMP), status 6 Data overflow Invalid Char value for cast specification.
And Row 63??? My destination table only has 3 rows populated??
I see you had another Cast specification error on this forum - i followed those instruction but nothing fixed my problem. The strange thing is I have this problem with 2 of 20 tables i am importing. The other table have data time also but no problems on those.
Any suggestions would be greatly appreciated
Thanks
Karen
March 13, 2002 at 5:48 am
Karen,
Even though SQL Server and Access talk to each other very well, there are a few things you need to be aware of. One of those is the date data type. In ordert to get get it right you will need to use a convert or cast function.
Like: Cast(SampleDateField AS varchar(16)) or something like that.
If you place a sample of your date field it will be easier to give you a clue.
Anyway, Books-On-line has samples on how to use the cast or convert functions.
Good luck.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply