1

I have three different list seperated by Area (NY, NJ, and CT) is there a way to build a report in the database that will pull all records from all lists? I exported all three to excel one by one, but they are all formatted different which makes combining them all an absolute nightmare. I need the ability to pull 1 bulk report that pulls from all lists.

3
  • Does all the tree lists has same field schema? Jun 29, 2016 at 13:04
  • what is field schema?
    – user56323
    Jun 29, 2016 at 13:10
  • field structure or the list of columns in all the lists Jun 29, 2016 at 13:25

2 Answers 2

1

With Microsoft Access you can link all 3 SharePoints lists, built a Query and Export whatever you want

0

There is not direct out of the box way to do this. One option is

  1. Export first list to Excel
  2. Now change the connection name to List1
  3. Export second list to Excel. Here choose new WorkSheet instead of WorkBook
  4. Change the connection name to List2
  5. Export third list to Excel and choose new WorkSheet
  6. Change the connection name to List3

Now you can use Excel operations to combine the three sheets into one.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.