Hi I am using Data Migrator Tool reading the data from Excel by using Excel Adapter the values shown in Excel with number followed by Single Quote (') stays as number in Data Management Console after sampling the data from Excel as it assigns Alpha fixed in bytes as data type but it changes all the other numeric data as it type it text to Date

for Example

Data in Excel Data in Data Management Console after Sampling

'001 001

101 04/10/1900

As data in Excel saves as text type for both single quote or without but one with single quote stays the same as it need to be but on the other hand without quote change to date format instead of keep the same data and it assigns Alpha fixed in bytes as data type in Data Management Console

Did any body know how to fix this issue at Data Migrator level , what the workaround about this issue ?

This message has been edited. Last edited by: Tamra,

Hi Najam,

Welcome to Focal Point.

While we wait for other members to reply to your request:
IWay Data Migrator Tool Data Coversion Automatically To Date Format as Excel as Sourc .
This sounds like something a case should be opened for and that way if this is a real issue it can be tracked properly.

Please keep us informed if you do open a case and what the resolution is. Other members will be interested in hearing the outcome.

Thank you for participating and sharing in Focal Point.

Kindest regards,
Tamra Colangelo
iWay Focal Point Moderator