Hi
I have a series of queries, I have a number of temp tables which I use
as templates for my data.
I start with
1. Delete the data in a temp table
2. Use append query to fill the temp table with data
Now, in the temp table, I have a memo field. I append information from
a text column (Oracle DB) into the memofield in the temp table. For
some reason, only the first 255 characters copied across as if it
takes that column in the temp table as a text field.
Why is this and how to work around it?
Many thanks
Padthai