User Friendly CSV to MSSQL import with column match

Hi before I reinvent the wheel I'm trying find something to allow a user to take .csv files and graphically match the columns in the database table to the columns in the csv file. I know this can be achieved using the mssql import/export wizard or SSIS however if the column don't match exactly you start getting into t-sql. Anything ? Thanks

Try with Quick CSV Import or DevArt dbForge studio .

I'd suggest you look at Data Transformer (disclaimer - I'm its developer). It can convert CSV to SQL (and others). The generated SQL contains "insert" statements for each line and a "create table" statement.

The app works offline - your data never leaves your machine.

You can get it from the Mac App Store or the Microsoft Store.