[AccessD] Memo field - export data

Griffiths, Richard R.Griffiths at bury.gov.uk
Thu Mar 24 08:25:49 CST 2005


The data displays okay in A97 - its only the export bit that does not
work.  I now have a solution - I imported the A97 db into SQLServer and
exported it from there.
Thanks

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: 24 March 2005 14:08
To: Access Developers discussion and problem solving
Subject: Re: [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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list