hi there,
I facing some issue about the data type between access and sql server. I can't import my data that under access to sql server. it keep on prompted me 'General error-2147217891 (80040EID). Does anyone there faced this kind of problem? if someone familiar with upsizing access to sql process, please tell me what is the issue between these data type in access:hypelink, yes/no,image..and so on (essential data type that will affected after upsize. Furthermore, index of table and relationship between table. Because I just upsize the table structure without the table relation, does it affect anything?..
thanks
I facing some issue about the data type between access and sql server. I can't import my data that under access to sql server. it keep on prompted me 'General error-2147217891 (80040EID). Does anyone there faced this kind of problem? if someone familiar with upsizing access to sql process, please tell me what is the issue between these data type in access:hypelink, yes/no,image..and so on (essential data type that will affected after upsize. Furthermore, index of table and relationship between table. Because I just upsize the table structure without the table relation, does it affect anything?..
thanks