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?