truncation of "memo" datatype during export


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
 
Ad

Advertisements

J

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
 
Ad

Advertisements

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top