title: How do I import data into a SQL Server with auto detect column data type?
body: <p>I have a nicely formatted csv file with over 100 columns.  I tried using the SQL Server Import and Export Wizard, but it has no feature to auto-detect the appropriate type of each column, defaulting the type to varchar(50).  Is there an alternative method where I can load the csv into a table and have auto-detect?</p>