Create a table in SQL Server based on a definition row in Excel WITHOUT using sampling
<p>I want to create a table in SQL Server and define the column names AND types in rows such as below - please READ ON after the picture. Like this: </p>

<p><a href="https://i.stack.imgur.com/NXniQ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NXniQ.jpg" alt="enter image description here"></a></p>

<p>I've already research and know of ways in which you just define COLUMNS in excel and under each column you give some sample values and SQL Server automatically creates a table with those columns, but the column types are "guessed" after sampling the first, let's say 100 rows (you can adjust the sampling size). This does <strong><em>NOT</em></strong>  work for me. My table has a lot of variations (VarChar1, 2, 3, 5, or even CHAR). So I want to be able to define it using a description as shown above. Anyone has a solution? Thank you so much in advance! </p>