I'll lead with a very short solution #2 at http://www.codeproject.com/Questions/546165/howplustopluscopyplusthepluswebpluspageplustabelpl
You or your programmer can expand that to fit your need and get it into your database.
A second approach is to file a Freedom Of Information (FOI) request for the data in CSV or other format.
In closing, once in awhile a non-programmer asks this. I've yet to find a non-programmer solution except for FOI.
I am trying to create a database from a set of public comments submitted via regulations.gov. There will be over 240,000 separate comments (each has a separate webpage), and I do not have the time to copy and paste the information from each into an excel spreadsheet. Is there a way to extract the data in one action? I've tried creating a query in Excel, but it didn't work. I'm using Excel 2011 for Mac, OS X version 10.8.3, and Firefox. Thank you so much for your help!