Truncating memo field

[Tamara]

I have read through the posts on why a memo field truncates and can't seem to
find any of the possible reasons. Here is my query:
-----
SELECT [Portfolio List].[PRISM ID], Import_All_Project_Statuses.[TARGET
END], Import_All_Project_Statuses.[CURRENT PHASE], Left([Status Details],1)
AS Overall_Status, Mid([Status Details],InStr([Status Details]," ")+2) AS
Overall_Details INTO RawData_ProjectStatus
FROM [Portfolio List] LEFT JOIN Import_All_Project_Statuses ON [Portfolio
List].[PRISM ID] = Import_All_Project_Statuses.ID;

 

[John Spencer]

If you run your query as just a SELECT query is the data in the memo field
truncated? Since you did not tell us WHICH field is being truncated it is hard
to guess why.

Something to try:
Instead of using a make table query, create the table first and define the
memo field as a memo field. Then use an append query to add the records to
the table. It could be a bad guess on what field type is needed - text or
memo based on who knows what algorithm.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Tamara]

Mybad...of course you need to know which field is truncated. The query
splits the original field (Status Details) into two target fields (Overall
Status which contains the first word and Overall Details which contains the
rest of the field). Overall Details is the field that is truncated.

If you run your query as just a SELECT query is the data in the memo field
truncated? Since you did not tell us WHICH field is being truncated it is hard
to guess why.

Something to try:
Instead of using a make table query, create the table first and define the
memo field as a memo field. Then use an append query to add the records to
the table. It could be a bad guess on what field type is needed - text or
memo based on who knows what algorithm.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

I have read through the posts on why a memo field truncates and can't seem to
find any of the possible reasons. Here is my query:
-----
SELECT [Portfolio List].[PRISM ID], Import_All_Project_Statuses.[TARGET
END], Import_All_Project_Statuses.[CURRENT PHASE], Left([Status Details],1)
AS Overall_Status, Mid([Status Details],InStr([Status Details]," ")+2) AS
Overall_Details INTO RawData_ProjectStatus
FROM [Portfolio List] LEFT JOIN Import_All_Project_Statuses ON [Portfolio
List].[PRISM ID] = Import_All_Project_Statuses.ID;

 

[Tamara]

I tested your suggestion on creating the table then using append. Works
great after creating/running a delete query first.

If you run your query as just a SELECT query is the data in the memo field
truncated? Since you did not tell us WHICH field is being truncated it is hard
to guess why.

Something to try:
Instead of using a make table query, create the table first and define the
memo field as a memo field. Then use an append query to add the records to
the table. It could be a bad guess on what field type is needed - text or
memo based on who knows what algorithm.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

I have read through the posts on why a memo field truncates and can't seem to
find any of the possible reasons. Here is my query:
-----
SELECT [Portfolio List].[PRISM ID], Import_All_Project_Statuses.[TARGET
END], Import_All_Project_Statuses.[CURRENT PHASE], Left([Status Details],1)
AS Overall_Status, Mid([Status Details],InStr([Status Details]," ")+2) AS
Overall_Details INTO RawData_ProjectStatus
FROM [Portfolio List] LEFT JOIN Import_All_Project_Statuses ON [Portfolio
List].[PRISM ID] = Import_All_Project_Statuses.ID;