access problem

[rams]

hello all!

when i am tranferring data from a Microsoft access table to a sql server table i get the following error.

"Invalid character values for cast specification"....

any ideas????

[GANESH]

I encountered this problem most often when converting date from access to smalldate in SQl server. A good way can be to to edit SQl during the change so that the new table in SQl has dae stored as date instead of smalldate.

Another problem can be with memo fields. See if any memo fields are curropted. Compact the database and repair it in access and try again . If you can't do compacting then the momo filed or old object might hacve got curropt.


------------
rams at 11/17/00 7:07:47 AM


hello all!

when i am tranferring data from a Microsoft access table to a sql server table i get the following error.

"Invalid character values for cast specification"....

any ideas????