I would like to import data from an Access table into Pro-IV using DDE. I can set up the DDE connection and even retrieve basic information like the number of fields in a table or all the data in a table. The problem arises when I try to perform any SQL on the Access data. Any help on this would be appreciated.

Also, the Access data is returned to Pro-IV as a tab delimited alpha string. I've tried performing a INDEX routine on the data using CHAR(9)to segment the data into specific fields but to no avail.

Much obliged.
Neil Cowburn
JEM Business Systems Ltd.