inserting numbers into table instead of text

[dhx10000]

Hi,

I have a strange problem, I have created this query:

INSERT INTO WEEKONE ( Assigned_To )
SELECT QPTActions.Assigned_To
FROM QPTActions
WHERE QPTActions.Entry_Date<=DateValue('1/2/2006') And QPTActions.Close_Date>DateValue('1/2/2006');

It works, but it inserts Numbers into the Assigned_To column in the table WEEKONE. When I looked in the QPTActions database the values are text but the type of column was originally set to Number. I changed this to Text but its still inserting Number values into the destination table. How can I fix this?

 

[dhx10000]

Nevermind...this was a dumb problem with a lookup field. I had the
'Retrieve IDs for lookup columns' checked, when importing a table.