Create SQL table from Excel VBA

[angil0126]

Hello -

I have the following table in Excel

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]SLCo[/TD]
[TD]SL[/TD]
[TD]CompCode[/TD]
[TD]APRef[/TD]
[TD]Amount[/TD]
[TD]Release[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]19[/TD]
[TD]CM[/TD]
[TD]967[/TD]
[TD]5000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]19001-01P[/TD]
[TD]CM[/TD]
[TD]19001-0719[/TD]
[TD]10500[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]123546-A[/TD]
[TD]CM[/TD]
[TD]123658-1[/TD]
[TD]15000[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]56875-4[/TD]
[TD]CM[/TD]
[TD]9856-7A[/TD]
[TD]7500[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]32587-4[/TD]
[TD]CM[/TD]
[TD]5647-8[/TD]
[TD]21500[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Using VBA on a button, I'd like to do the following:

- Execute a Stored Procedure in SQL database that creates a temp table with columns SLCo, SL, CompCode, APRef from the data above ONLY where Release = X
- Updates existing table based on matching records found in temp table
- Delete temp table

I can create the table (I think), but am at a loss as to how to populate with the records only where Release = X

Any help would be greatly appreciated!

 

[Steve_]

You will need to use an SQL statement when creating the table.

Select * from TABLE_NAME where Release like 'X'