Forum Discussion
Problem with data type from an excel file
I have a table of data i import from excel with employee id as a column when i import the data the employee id with letters in them do not import i have tried changing the field to text and number an...
Almost certainly your query step has automatically set an integer number format early in the query. If you then switch it back to string later in the query - it is too late - the damage is done. Find the step "Changed data type" that turned it into Integer and delete that step. That should fix it.