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