Access 2000 SR-1
Problem Description:
-------------------------------
I have the following query which I am using to export data into CSV
format. In the resulting CVS file I am finding that the "description" ( of
"memo" datatype) column is being truncated. When I export in html format the
data does not get truncated. I need the data in a CSV format.
Any idea how I can work around this problem??
Here is the query:
SELECT reference, referenceseq, raisedby, raisedfunction, raiseddate,
investby, investfunction, investdate, len(description_rec) AS desc_len,
description_rec AS description
FROM [SELECT part1.Reference, part1.ReferenceSeq, part1.RaisedBy,
part1.RaisedFunction, part1.RaisedDate, part1.InvestBy,
part1.InvestFunction, part1.InvestDate, description & '||' as
description_rec
FROM part1
]. AS mig_part1;
Thanks in advance
John Nurick - 30 Jun 2006 21:45 GMT
Hi Mathew,
This looks like the problem described at
http://support.microsoft.com/?id=207668
"When you export a query that contains an expression that results in
more than 255 characters, the expression is truncated in the exported
file."
The article also describes the work-round.
>Access 2000 SR-1
>
[quoted text clipped - 20 lines]
>
>Thanks in advance
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
Mathew Butler - 04 Jul 2006 13:46 GMT
John - great spot.
This was my issue and the workaround actually works!
Many thanks for taking the time to respond.
Mat
> Hi Mathew,
>
[quoted text clipped - 36 lines]
>
> Please respond in the newgroup and not by email.