[AccessD] Memo field - export data

Does the data display properly in a Paradox report? Perhaps you could
create a report to display the memo data along with some key info to
use to hook it back to the underlying data and then print that report
to a FILE. Then you can read that text file in as data and parse
through the info and put the peices back together. Maybe. ;-)

If nothing else, seeing if the data can be read for a report would
tell you if the data structure itself is corrupt or intact.

To set up the print to text printer driver see this;
http://support.mfm.com/support/std_procedures/xpgenericprinter.html

Or do a web search on "windows generic text only printer" and you will
find lots of info on it.

Good luck with your project.


On Thu, 24 Mar 2005 11:56:24 -0000, Griffiths, Richard
<R.Griffiths at bury.gov.uk> wrote:
> Hi
> 
> Under pressure to get a job done!!!
> 
> 1. Have a table (from paradox) inA97.
> 2. Trying to export to text file
> 3. One of the fields is a memo field - field may contain 10, 20, 30000
> characters of data.
> 4. Export does not copy out all this data (only 500 or chars)
> so...........
> 5. Have written code to print line into a text file (open/write etc) but
> this crashes when I come to a record where the field contains large
> amount of data as above.
> 
> I am missing something?  Do I need another approach (appendchunk?) or
> are my problems related to dodgy/corrupt data.
> 
> Many thanks in advance
> 
> Richard
> 

-- 
Gary Kjos
garykjos at gmail.com