Hi listers,
I know how to use ado object to query and return the result to the Datagrid.
What I want to know is how I can perform the below listed SQL query and export the result directly to a dbf file?
In this case, the expoert dbf file is 'query.dbf'. and the SQL statement is
"SELECT FILE.file_name, FILE.out_to, BORRCODE.TYPE, BORRCODE.RANK into query.dbf FROM FILE RIGHT JOIN BORRCODE ON FILE.OUT_TO = BORRCODE.TYPE"
Thanks

junno