Table Copy

[murkay]

I copy a table from MsAccces to MSSQLServer.
I use crbatch or uniloader.
Source is type memo destination is type varchar(5000).
When I perform copy destination table value is only first character of source value.

[murkay]

When I use with Destination Connection
with DataTypeMap.Add do begin
DBType := 318;
DBLengthMin := 500;
FieldType := ftWideString;
end;
i.e.
DataTypeMap.AddDBTypeRule(318,ftWideString);
It works
Is it a good solution ?

[AlexP]

Hello,

Thank you for the information. We have reproduced and fixed the problem with cutting data when using CRBatchMove. This fix will be included to the next version. For the time being you can use Data Type Mapping