Tam
Tam

Reputation: 11

Repeat sql request for different criteria and export excel file at each time

I have a database with data from 2017 to 2019 of different sites (like different cities). I want to extract one table excel for data of one site in one year, for example site A in 2017, site A in 2018, site A in 2019 then site B in 2017, .... I want to use each file for an analyse with python later. Is there a way to automate the request to do this ? I have almost 10000 sites so I want to have then 10000*3 excel files, and it take a lot of time to change critera of "where" at each time. If it is possible to automate this process, I can then launch it at night.

Thank you in advance,

Upvotes: 0

Views: 35

Answers (0)

Related Questions