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?