>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.0You 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")
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.