truncation of "memo" datatype during export

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
 
John - great spot.

This was my issue and the workaround actually works!

Many thanks for taking the time to respond.

Mat

John Nurick said:
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
Click to expand...
Click to expand...
 
Back
Top