Link to home
Create AccountLog in
Avatar of dindin1
dindin1

asked on

Export memo field from Foxpro Mac

I have a database in Foxpro Mac 2.5 containing two memo fields which I need to transfer to Filemaker Pro 9. I have not been able to find a way to do this. The file has nearly 800 records so I don't want to have to transfer it manually record by record.
Avatar of CarlWarner
CarlWarner
Flag of United States of America image

How to Export Memo Fields to an ASCII File
http://support.microsoft.com/kb/95722/en-us
Avatar of dindin1
dindin1

ASKER

My memo fields have over 254 characters (some have many pages) so only solution that applies is the low-level I/O one. When I type that in the command field I keep getting "Statement not allowed in interactive mode". I don't know what that means. So I have not been able to use that solution so far.
It means it works fine in a prg/program file.

Put the code in a prg file and run it.
Avatar of dindin1

ASKER

I am working on it but having trouble with syntax for FCREATE.
Avatar of dindin1

ASKER

Sorry to be such a klutz. Now getting message "variable numfield not found",  also for memo1 and charfield. I think I am making every possible error.
ASKER CERTIFIED SOLUTION
Avatar of CarlWarner
CarlWarner
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of dindin1

ASKER

Thanks so much. I have successfully converted a memo field to an ASCII comma delimited field and now am working on importing it into Filemaker Pro 9.