Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / July 2006

Tip: Looking for answers? Try searching our database.

truncation of "memo" datatype during export

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mathew Butler - 30 Jun 2006 14:28 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.