Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Convert HTML table to a VFP9.0 table 2
- Thread starter fourletr
- Start date
-
1
- #2
TamarGranor
Programmer
Take a look at STREXTRACT(). It's pretty good for parsing this kind of data. Also, if you have a choice, use XML rather than HTML, and you can use either XMLToCursor() or XMLAdapter to pull the data out.
Tamar
Tamar
-
1
- #3
Olaf Doschke
Programmer
Tamar is right that html tables are not at all ideal for storing data and getting it back, you better go XML.
But for the sake of pointing out all the options, if you show a html table in a browser or webbrowser control, right clicking offers the option to export to excel.
Then again vfp has problems reading in xls files of new excel versions, but you can go through ODBC/OLEDB to query excel sheets. At least there are commands like IMPORT and APPEND FROM to work on xls, but not for html.
Bye, Olaf.
But for the sake of pointing out all the options, if you show a html table in a browser or webbrowser control, right clicking offers the option to export to excel.
Then again vfp has problems reading in xls files of new excel versions, but you can go through ODBC/OLEDB to query excel sheets. At least there are commands like IMPORT and APPEND FROM to work on xls, but not for html.
Bye, Olaf.
- Status
