Hi,

Thank a lot for your help and advise. I managed to get it to work. However,
i like to know how do I close the file after use in the SQL command like

SELECT * FROM 'C:\my installations\report\data', 'c:\my installations\data\data_file' INTO DBF 'C:\temp file\test'


How do I close all the source file - data_file and data file are used. Can
using the command 'USE ' only close all the data file.

Thank in advance.









>>Hi,
>>
>>I like to know how do we change the long path name and filename obtain from the GETFILE() into the DOS short form name ? I had problem opening the file in folder with long name like
>>
>>From
>>
>> USE C:\My Installation\Report
>>
>>TO
>>
>> USE C:\Myinst~1\Report
>>
>>
>>
>>Any help or advise is very much appreciated. Thank you.
>Hi,
>Although you could convert using winAPI, you don't need to, just include the name in quotes :
>USE "C:\My Installation\Report"
>Cetin