jbryer / ipeds

R R package for accessing the Integrated Postsecondary Education Data System (IPEDS) from R.
48 stars 18 forks source link

Adding Windows Support #20

Open erikb-thomas opened 9 months ago

erikb-thomas commented 9 months ago

This adds windows support to the download_ipeds function. The function uses the DBI and odbc libraries. Most windows users wont need to install anything, as the odbc drivers come with Microsoft Access. If a user does not have Microsoft Access, or the architecture of their Office install differs from their R install, they will need to install a stand alone driver from Microsoft from here: https://www.microsoft.com/en-us/download/details.aspx?id=54920

I read in some old issues discussions that users attempts to add windows support in the past took to long to function. DBI is significantly faster than the rodbc package they were using. On my machine, this function seems to take around 60 seconds after the download is finished to finish saving the rdata file.