We have bunch of lists in external SharePoint site (MOSS 2007) and I am looking for an efficient way to query, extract and bring that data to a different location preferably SQL Server to use in a report. Please share your experiences and any help is appreciated. Thanks in advance

(This isn't a Social Computing question so I'm moving it to Admin). An efficient way to create reports from SP 2007 lists is to link them to Access 2007 (each list is a synced Access table) and then use Access 2007 Reporting functions to create reports. There are several options for linking to Access 2007 so check that you have one that will sync) Hint: For reports from a single List use the Reporting wizard; for reports combining 2 or more Lists do NOT use the wizard but use the manual Editor.SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx Both also have links to extensive book lists and to (free) on-line chapters