We recently needed a way to extract files from a sharepoint site’s document libraries. With sharepoint all the files are stored in a SQL database so it would seem connecting to the database and pulling all the files out manually wouldn’t be such a hard thing to do. After a fair amount of time googling for such a solution I finally found it over at Mark Jen’s blog. Mark’s solution it turns out didn’t work for WSS 3.0 but in the comments a fella by the name of eric writes:

I have modified the code to work with SharePoint 07. Since the Content is stored in a new table with 07, the query piece needs to be a little different. Just replace line 24 with the sting below. It worked perfectly for me after that.

Find
com.CommandText =