Does the "With Character" clause work for you?
APPEND FROM GETFILE() TYPE DELIMITED WITH CHARACTER "!"
hth
-Stefan
>I am having a dickens of a time trying to append a text file into a table, which I've done several times before, but maybe I am leaving something out.
>
>
>USE C:\AMMSSQL\POHIST IN 0
>SELECT POHIST
>APPEND FROM C:\AMMSSWL\BK_ELECTRIC.TXT DELIMITED WITH "!"
>BROWSE
>
>
>What happens is that the first 10 characters go into the first field (but the data is only 7 characters for the first field, and the delimiter of "!" is also there as one of the 10 characters; it is as if the FoxPro APPEND FROM command completely ignored the delimiter. The field is 10 characters long, but the PO (Purchase Order #) data is only 7 characters long.
>
>So, I get the following data in the first field:
>
>0800607!04 <-- You can see that the delimiter is now part of the data, but why?
>
>What's going on here?