Hi Wai,

>i want to know if i use select - SQL to do some filtering from one table abd i want to export this filtered file and save it into my local harddisk. How can i do this?? can anyone help me?
>thanks~

local lcTableName
lcTableName='c:\test\test.dbf' && Type the existing directory and the real name you want to use
SELECT [SomeFields] From [Sometables] Where [SomeConditions] ;
       into table (lcTableName)

HTH