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