is there a way to replicate / "copy" the SQL server import feature of SQL server management studio? this way you can let an end user without SQL server management studio import data to database?
i.e. I need to customise my application with a user friendly form, where user picks data source e.g. Excel, SQL, Access and can import data to database?
so users can import data from things like
-Microsoft Office Access
-Microsoft Office Excel
without field names etc. having to match exactly