PDA

View Full Version : Excel to SQL Server



DivinationX
09-29-2009, 06:09 AM
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
09-29-2009, 06:31 AM
You need to look at ADO.

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

DivinationX
09-29-2009, 06:14 PM
Is it possible to do the example that you have provided with Visual Basic Editor that is provided in Excel?

Bob Phillips
09-30-2009, 01:00 AM
I believe that is what it is done with. It is certainly ossible, I query SQL Server from Excel regulalrly.