How to import Excel data using SQL Query (without wizard)?
<p>Say I have thousands of Excel files with all people's information.</p>

<pre><code>Name Height
John  182
Sam   178
...
</code></pre>

<p>If I want to import these data into a new MS-SQL database table using SQL query, how should I do that?</p>

<pre><code>Name  Weights
John  130
Sam   160
...
</code></pre>

<p>And now if I want to append 'Weights' data into previous table using query, how should I do that?</p>

<p>The reason I'm doing this is because import too much Excel using wizard can lead to a huge waste of time, so I'm thinking if I can embed SQL query in MATLAB, then a for loop will do the job for me, hopefully.</p>

<p>Thank you in advance.</p>