am giving it a try but i am doing something wrong here
select myfile.dbf gives me an error message
select 0 use myfile,dbf give me a table number is invalid message.

what am i missing.

k

>>thanks Borislav, i read that - WAY over my head.
>>k
>>
>>>>Me again answering some of the issues in my first problem.
>>>>if i open the file the re-save with format number 51 it will save as an xlsx.
>>>>is there a way of doing this using the copy method without going through the opening xl method.
>>>>
>>>>k
>>>
>>>Check Using Excel 2007 File Formats in VFP 9.0
>
>You need only CopyToExcel function (but you need to add the whole file in your project).
>Use it like this:
>

>SELECT YourTableYouWantToExport
>CopyToExcel("c:\Test Craig's BLOG\Test.XLSX", "Sheet1")
>