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
Jim Philippi
quando omni flunkus moritati