I need to import a .csv file into a table in SQL Server.

I need for the user to be able to select the file and then click to import that file.

What is the best way to go about this?