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