Here's an update:
It turns out the issue isn't with the export at all. Just caught the real issue. I have a table containing various fields, including the memo/long text field which is the issue. Before trying to export, I write the data into a different "combined" table. This is because my source table has multiple records which I want to combine into a single record based on a key field. Most of the fields are the same for the multiple records, but some differ between records. I can't use a group-by query because it's supposed to append data to a table. Also, instead of having aggregate functions for some fields, I need them accumulated differently. Sort of like this:
Code:
ID Name Paragraph1 Dates Amounts
3 Joe This is a paragraph 1/1/2020 $50
3/2/2020 $100
5 Bill Another paragraph 5/2/2020 $75
5/9/2020 $37
So, I run a query to select distinct the ID, Name & Paragraph1 and insert them into the combined table. Then I loop thru the source records and collect the dates and amounts into long strings, then update them into the combined table.
To paraphrase my first query, it's like this:
Code:
Insert into CombinedTable (ID, Name, Paragraph1) Select Distinct ID, Name, Paragraph1 From OtherTable
This is where the problem occurs, because the OtherTable has a Paragraph 1 of 270 characters, and in the CombinedTable it's truncated to 255 characters. So this post should have been titled "Insert query truncates data".
Do I need to end this thread and start another one? Thanks...
Another Update: Seems the problem is the Select Distinct. If I do a select query without the insert, it shows the full field. If I do a select distinct query, the long field is truncated. Has nothing to do with the insert part of the query above.