I have a 90 meg ascii file that I need to import into a table so I can use it. If i use the import wizard (in VFP5) it takes the first 52 characters and places them into a character field. I takes the rest (800 characters) and places them into a memo field. This is great but I would like to do it without going through the wizard.

If I create the structure, one character field and one memo field and then APPEND FROM SDF nothing goes into the memo field. If I APPEND MEMO it all goes into a single memo field rather than creating the 200k records. I haven't been able to get INSERT SQL to work either.

What am I doing wrong?

Thanks