Hi Srdjan

Thanks. As I said to Viv, I've already got code for dealing with an Excel file, which this customer's data came in originally. If I convert HTML to Excel then I can re-use the old code, to convert the data to a VFP table for use in our system.

Cheers

Terry

>>>>>>>>Is it possible to import an HTML file, in a spreadsheet-like format, directly into a VFP table? It's not in the syntax of VFP7's import or copy
>
>Hi Terry,
>
>There is one method that got very popular with my users
>that might work well in this case.
>
>- I show ordinary VFP form with large editbox field (memo).
>- User select/copy specific area of interest within excel file
>(That wld be desired excel area within HTML page)
>- User then paste entire selected content into that editbox/memo
>- Then he/she press ok or cancel
> * * *
>- After that copy/paste being done, all this content becomes one big multiline string which I chop consecutively into lines [with alines() ] and then process line by line. Since cells are separated by tab or something like that, I use it to further chop each line string into array and then
>parse those line-array elements into respective fields.
>
>Since there is no Automation involved it is very fast and very easy for users (comes down to copy/paste for them).
>
>HTH