Adding Memo Fields Using an Append Query

[Laz]

I have a simple Append Query to add four fields from one table to another.
The query works fine, except that no data is added for the Memo Field.

Are there some restrictions I should be aware of or any way that I can get
this to work – any help or guidance greatly appreciated.

Additional Information

This is the SQL view of the query…

INSERT INTO [News Test] ( Subject, Title, Body, Published )
SELECT [Microsoft News].Subject, [Microsoft News].Title, [Microsoft
News].Body, [Microsoft News].Published
FROM [Microsoft News];

Body is the Memo field that I am having trouble with.

 

[Ken Snell \(MVP\)]

I don't see anything in the query that would cause a problem with a memo
field being part of the append query.

If you run just this query, do you see data for the Body field:

SELECT [Microsoft News].Subject, [Microsoft News].Title,
[Microsoft News].Body, [Microsoft News].Published
FROM [Microsoft News];

 

[Laz]

Many thanks for taking the trouble to look into this.

Yes, I do see the data in the Body field.

Perhaps worth mentioning that the source data is WSS v2 list and the
destination is a WSS v3 list.

Louis.

I don't see anything in the query that would cause a problem with a memo
field being part of the append query.

If you run just this query, do you see data for the Body field:

SELECT [Microsoft News].Subject, [Microsoft News].Title,
[Microsoft News].Body, [Microsoft News].Published
FROM [Microsoft News];

--

Ken Snell
<MS ACCESS MVP>

I have a simple Append Query to add four fields from one table to another.
The query works fine, except that no data is added for the Memo Field.

Are there some restrictions I should be aware of or any way that I can get
this to work - any help or guidance greatly appreciated.

Additional Information

This is the SQL view of the query.

INSERT INTO [News Test] ( Subject, Title, Body, Published )
SELECT [Microsoft News].Subject, [Microsoft News].Title, [Microsoft
News].Body, [Microsoft News].Published
FROM [Microsoft News];

Body is the Memo field that I am having trouble with.

 

[Ken Snell \(MVP\)]

Forgive my ignorance, but what is WSS?
--

Ken Snell
<MS ACCESS MVP>

Many thanks for taking the trouble to look into this.

Yes, I do see the data in the Body field.

Perhaps worth mentioning that the source data is WSS v2 list and the
destination is a WSS v3 list.

Louis.

I don't see anything in the query that would cause a problem with a memo
field being part of the append query.

If you run just this query, do you see data for the Body field:

SELECT [Microsoft News].Subject, [Microsoft News].Title,
[Microsoft News].Body, [Microsoft News].Published
FROM [Microsoft News];

--

Ken Snell
<MS ACCESS MVP>

I have a simple Append Query to add four fields from one table to
another.
The query works fine, except that no data is added for the Memo Field.

Are there some restrictions I should be aware of or any way that I can
get
this to work - any help or guidance greatly appreciated.

Additional Information

This is the SQL view of the query.

INSERT INTO [News Test] ( Subject, Title, Body, Published )
SELECT [Microsoft News].Subject, [Microsoft News].Title, [Microsoft
News].Body, [Microsoft News].Published
FROM [Microsoft News];

Body is the Memo field that I am having trouble with.

 

[Laz]

Hi Ken

Apologies for the long delay in responding - problesm getting to this site

WSS is Windows SharePoint Server.

I figured out what the problem was - the target Memo Field was using an
enhanced version of Rich Text - changed it to the standard one and everything
worked perfectly.

Thanks

Forgive my ignorance, but what is WSS?
--

Ken Snell
<MS ACCESS MVP>

Many thanks for taking the trouble to look into this.

Yes, I do see the data in the Body field.

Perhaps worth mentioning that the source data is WSS v2 list and the
destination is a WSS v3 list.

Louis.

I don't see anything in the query that would cause a problem with a memo
field being part of the append query.

If you run just this query, do you see data for the Body field:

SELECT [Microsoft News].Subject, [Microsoft News].Title,
[Microsoft News].Body, [Microsoft News].Published
FROM [Microsoft News];

--

Ken Snell
<MS ACCESS MVP>


I have a simple Append Query to add four fields from one table to
another.
The query works fine, except that no data is added for the Memo Field.

Are there some restrictions I should be aware of or any way that I can
get
this to work - any help or guidance greatly appreciated.

Additional Information

This is the SQL view of the query.

INSERT INTO [News Test] ( Subject, Title, Body, Published )
SELECT [Microsoft News].Subject, [Microsoft News].Title, [Microsoft
News].Body, [Microsoft News].Published
FROM [Microsoft News];

Body is the Memo field that I am having trouble with.