> Stefan, the main problem is how to retrieve memo data from cursor, which that i get the cursor from odbc connection..i want to put all the data into dbf table, thank you for your respond..thanks
>
Not sure if I understood what the problem exactly is...
As a summary attempt, you are retrieving your data from a given XLS file via ODBC or OleDB successfully
so that they are available in a SPT result cursor.
Then you can determine the previously unknown column names via AFields() and create a SQL command on the fly.
What happens next, what line of code gives you what error or unexpected result?
-Stefan