How to insert records into SQL server from Excel

Question

I am not great at programming but I am getting by and I just want to update a sheet in excel into a table in SQL server 2012.

I can create the connection, insert HARD values but for some reason I cannot figure out how to insert ranges.

That is, the following code works fine:

objConnection.Execute "USE database1 INSERT INTO tblExposure(AssetID, Name) VALUES  (1234, 'Metoo')"

But, when I try to substitute a range, like Range.("A3").Value, I cant get it working.

objConnection.Execute "USE database1 INSERT INTO tblExposure(AssetID, Name) VALUES  (Range("A3").Value, 'Metoo')"

Thanks for the help

i cant get it working is not a good description of a problem. — Beau Grantham
– Beau Grantham, Commented Jun 11, 2012 at 19:04

Fionnuala · Accepted Answer · 2012-06-11 19:04:08Z

3

You need to put the range outside the quotes:

"USE database1 INSERT INTO tblExposure(AssetID, Name) VALUES  (" _
   & Range("A3").Value & ", 'Metoo')"

answered Jun 11, 2012 at 19:04

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1