Table Wizard offers a quick & dirty way to get a csv into a Drupal mysql DB as a table. You need to start by downloading & enabling tablewizard and schema. Make sure you choose to enable the delimited import part.
You should then be able to navigate to admin/content/tw via the content menu and upload your csv file.
If you want the table available in views, However you need to access MySQL (e.g via PHPMyAdmin)
and add a primary key column e.g.