Excel to SQL Server

[DivinationX]

Hi all, i'm new to MS Excel and of course to VBA too. Would like to extract data values from excel and insert them into DB, can that be done? Where do i start from? Do guide me. Thanks.

[Bob Phillips]

You need to look at ADO.

See here http://www.excelkb.com/article.aspx?id=10059

[DivinationX]

Is it possible to do the example that you have provided with Visual Basic Editor that is provided in Excel?

[Bob Phillips]

I believe that is what it is done with. It is certainly ossible, I query SQL Server from Excel regulalrly.