How about????

SELECT 0
USE Vendor_edi_wires_work_orders_tmp
* this is a remote view of an empty SQL table
=CursorSetProp("Buffering", 5, "Vendor_edi_wires_work_orders_tmp")
APPEND FROM wires_work_orders
=TABLEUPDATE()

>As you suggested, I tried
>
>
>I tried :
>Open Database vendor_edi
>SELECT 0
>USE Vendor_edi_wires_work_orders_tmp
>* this is a remote view of an empty SQL table
>=CursorSetProp("Buffering", 5, "Vendor_edi_wires_work_orders_tmp")
>SELECT 0
>Use wires_work_orders excl
>*this is a DBF defined in a DBC with exact same field names as SLQ table.
>INSERT INTO Vendor_edi_wires_work_orders_tmp FROM wires_work_orders
>
>Error was Command contains unrecognized phrase/key word
>
>
>
>So I tried:
>INSERT INTO dbf(“Vendor_edi_wires_work_orders_tmp”) FROM dBF("wires_work_orders")
>
>Error was Syntax error
>
>Can you give me a suggestion?