<div>
Is this data going into an existing table? &nbsp;Or is the excel spreadsheet making a new table?
</div>


Is this data going into an existing table?  Or is the excel spreadsheet making a new table?

<div>
ok basically what needs to happen is the existing SQL table cleared of all data..and the excel data inserted in the SQL table..<br />
<br />
so concievably either method would be fine.. whether it just updates the data, or removes the table and creates a new table..
</div>


ok basically what needs to happen is the existing SQL table cleared of all data..and the excel data inserted in the SQL table..

so concievably either method would be fine.. whether it just updates the data, or removes the table and creates a new table..

<div>
Thanks for the feedback..just a few clarifications needed.<br />
The Data Transformation Wizard looks exactly what Im after..however can this be scheduled or update automatically..<br />
ie. the data transformation needs to be completed without any user interaction..<br />

</div>


Thanks for the feedback..just a few clarifications needed.
The Data Transformation Wizard looks exactly what Im after..however can this be scheduled or update automatically..
ie. the data transformation needs to be completed without any user interaction..


<div>
answered my own question.. lol
</div>


<div>
<div class="content wysiwyg-content">
Hey ,<br />
<br />
Im looking for quickest and easiest way to transfer data from an Excel file into an SQL Server database..<br />
<br />
I am in the position where on a regular basis I will need to move data across from Excel to SQL and am looking for a way to automate the process..<br />
<br />
all suggestions welcomed!
</div>
</div>


Hey ,

Im looking for quickest and easiest way to transfer data from an Excel file into an SQL Server database..

I am in the position where on a regular basis I will need to move data across from Excel to SQL and am looking for a way to automate the process..

all suggestions welcomed!

Excel --&gt; SQL

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Excel --&gt; SQL

Excel --> SQL