You can do it in two ways :
You can have memory variables that match the name of your fields and say
INSERT INTO MyTableName FROM MEMVAR

or you can say

INSERT INTO dbf_name [(fname1 [, fname2, ...])]
VALUES (eExpression1 [, eExpression2, ...])

I prefer the second one, good luck

Hi All,
>What is the trick to having some text go into a memo field when you do an Insert-SQL command? It seems like I have done this before.
>TIA,