truncation of "memo" datatype during export

[Guest]

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]

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

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

 

[Guest]

John - great spot.

This was my issue and the workaround actually works!

Many thanks for taking the time to respond.

Mat

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

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