At 10:49 AM 3/13/2009, Jim Belisle wrote:
I was able to append the information from three tables into one table. I noticed however that some of the information from the columns did not append properly. If the destination col is not wide enough for the appended info, does it not append at all? Is there a setting that would truncate it so at least most of it gets into the table?
You need to compare the actual tables, matching column names, and data types. If the column name and data types are exactly the same, you should NOT be missing or end up with a truncated values when using the APPEND command. Very Best R:egards, Razzak.
