> > 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

when i try to show the result, data type become memo field, i cannot read the value directly, i need to double click the row first. but thanks that has been solved already.