Hi :) I was pointing you to the Getting Started with Base documentation because i thought you were just asking about migrating from MS Office Access to Base and needed to know about Queries in Base.
Your question seems to have become much more complicated so it might be better on the devs mailing list because i doubt any on the users list know how to do this sort of thing. Good luck and regards from Tom :) ________________________________ From: nwchrisb <[email protected]> To: [email protected] Sent: Fri, 3 June, 2011 5:43:07 Subject: [libreoffice-users] Re: QueryTables equivalent? Hi Tom, Thanks for your response. Which specific document on that page are you referring to? Page 36 in the overall starter guide (http://wiki.documentfoundation.org/cgi_img_auth.php/f/f7/0100GS3-GettingStartedLibO.odt) is about fonts (the PDF page 36 is similar). Just to clarify: I'm not trying to use a relational database. I really just want to parse a web page which has a lot of data. I need to do it programmatically because the number of quarters of historical data will vary by company. That is, I need to call http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=GLW&istart_date=0 http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=GLW&istart_date=1 http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=GLW&istart_date=2 etc. until I get no more data. In addition, I need to easily get the data onto one sheet. I was hoping to do it without writing the scraper myself, since opening a calc sheet as a "web query" works quite nicely. I was unable to figure out if this GUI functionality would allow me to collate multiple queries, however. Thanks Chris -- View this message in context: http://nabble.documentfoundation.org/QueryTables-equivalent-tp3013283p3018551.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
