This is what my teacher game to us:You will connect Excel to a database and design an ‘import dialog’We will use DuckDB for this lab.
https://duckdb.org/docs/api/odbc/windows.html
You will need to:download the database from D2Lset up the ODBC connectionStory: You work for a growing company in Topeka, KSYou are tasked with finding a new officeYou think you need at least 40k sq feet.Your boss wants to spend a minimal amount of money.But perhaps you can get a better deal by gettingtwo smaller offices? If you use that strategy, the twosites should be no more than 3 miles apart.The import dialog should load the list of properties.The user can select one to see it’s address, lease, and sq ft.Use text boxes (?)They can click a “generate report” button thatcreates a new sheet that contains all viableproperties that could pair with the selected one.