Language: Visual Basic

Problem 7-3 Exoplanets - Download the file Exoplanet.txt. Each line of the file is like a database record. Each line contains the following information:

• Name of the planet
• Name of the star the planet orbits
• Number of earth days in the planet's year
• Distance from the Earth in light-years

Have your program retrieve the data from Exoplanet.txt and store each planet's data into an array of a structured variable.

• All unique star names should be listed in the first list box, a star names list box. The list of star names should be in alphabetical order.

1. You MUST use a query to select the star names from the planet array
2. Your program must add the unique star names in alphabetical order to the star names list box when the program loads

• After the program loads, the user should see a list box with the star names. The user must select a star name from the list box.
• When the star name is selected,

1. a second list box (for planets) should be cleared of all contents
2. a query should select all the planets around the selected star
3. a list of all planets around the selected star should appear in alphabetical order (A-Z) in the planets list box;

Exoplanet Data:

Earth,Sun (Sol),365.24,0 Proxima Centauri b,Proxima Centauri,11.186,4.22 Gliese 667 Cc,Gliese 667 C,28.143,23.62 Kepler-442b,Kepler-442,112.3053,1291.6 Kepler-452b,Kepler-452,384.8,1402 Wolf 1061c,Wolf 1061,17.9,13.8 Kepler-1229b,Kepler-1229,86.8,769 Kapteyn b,Kapteyn,48.6,13 Kepler-62f,Kepler-62,267.291,1200 Kepler-186f,Kepler-186,129.9459,561 Luyten b,Luyten's Star,18.65,12.36 TRAPPIST-1d,TRAPPIST-1,4.05,39 TRAPPIST-1e,TRAPPIST-1,6.1,39 TRAPPIST-1f,TRAPPIST-1,9.2,39 TRAPPIST-1g,TRAPPIST-1,12.4,39 LHS 1140 b,LHS 1140,25,40 Kepler-1638b,Kepler-1638,259.365,2491.83 Teegarden c*,Teegarden's Star,11.4,12.58