I ran into errors recently when I tried running a large UNION query (about
6,900 news articles) in a desktop Access database, that will eventually be
migrated to SQL Server. I've got two tables, each having the same typed
fields. I joined then through the following query:

SELECT ID,Name,Body FROM Table1 UNION SELECT ID,Name,Body FROM Table2;

The problem was that in the resultant table containing the conjoined
records, one of the fields (Body, a MEMO field) copies only the first 250
characters or so, truncating the rest of the data.

I was thinking this might have something to do with telling Access how to
type the data when copying it over. Is there a way to explicitly tell a
query the data type of each field to be used so that the data can be copied
over properly?

Thanks!