Post reply

DTS ignoring Memo Fields In FoxPro

  • February 17, 2004 at 9:14 am

    #63382

    When i preview the data from source in DTS it shows me the records. But when i try to test the activexscript it does not retrieve the data from the Memo Field. Has anyone faced this problem before. Are there any work arounds. I tried changing the field to Char but it erased all the data from the memo field.

    Thanks...

  • February 18, 2004 at 5:39 am

    #494498

    I had a problem similar to this.  Foxpro seems to store its memo fields in an external file.  I got around some of these problems by first opening the file in excel and it pulled the memo fields in perfectly.  I then exported from excel to a dbf file.  Then you can import this using DTS.  This is probably an ugly work around but this worked for me when I had to do some reporting on someone's fox pro data tables.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply