>>>>>I suggest to not attempt to use Import command anymore. Check Craig Boyd's program or try APPEND FROM. I recommend the first and I recently implemented it in my utility.
>>>>
>>>>I don't know which Craig Boyd's program you mean so maybe when you come back to UT on Sunday you can let me know. And I didn't know that APPEND FROM can be used for Excel spreadsheet; or maybe I am mistaken.
>>>>Thank you.
>>>
>>>The solution I meant is
http://www.sweetpotatosoftware.com/SPSBlog/CommentView,guid,6b9d4c6f-76bb-4444-8d5b-9e321c605534.aspx>>
>>Have you actually used this program of Craig Boyd to convert data in Excel 2007 to a DBF?
>
>Yes, I used that program to put data from Excel into DBF (a cursor).
Maybe you can help me with two questions:
1. When I look at the sample code I am not sure if the table/cursor where the data is copied from an Excel (when you call Appendxlsx.prg) has to be created beforehand or the .prg creates it?
2. In the sample code Craig has Excel field list as "column1,column2,column3. But typically Excel columns have names like A, B, C. Do I misunderstand this parameter?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
