>>>>>>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 cursor must be created in advance, I believe. I don't remember where he lists column1, etc. Can you show the relevant piece of code?
If it's not broken, fix it until it is.
My Blog