sql excel ado

I have a separate method for database query. But I dont know how to connect it with combobox items? Whereas, if I select Combobox1 item1 it will direct to query and on button click will execute query. I tried putting it in Select Case, but not working. Thank you!

Hi everyone - Running into an issue on assigning the value to the cell with the following statement: Sheets("DASHBOARD").RangeR1C1(RowPos + i, StartPos + i).Value = rs(i) I am calling a SQL statement to fetch the data to post against the dashboard. The SQL statement has been simplified for...

Hi I'm doing simple connection to MS SQL and want to get count and display into excel: Sub test() Dim conn As ADODB.Connection Dim rcrds As ADODB.Recordset Dim iRowNo, i As Long Dim id, name, value As String Dim wb As Workbook Dim ws As Worksheet Set wb =...

Hello All, I am having the most wretched time trying to figure this out. I have a worksheet with merged cells (I cant change the input format, I know, I know merged cells are evil and very true for me right now). But anyway in order to get the data I need I have to run 2 queries which works...

Hi, I have data as: <tbody> id name value 1 A1 1 2 A2 22 3 A3 33 ... .... ... </tbody> How to export the data (Range:A1:C&i) to MS SQL server, to table called "test"? I know how to get/select the data from MS SQL: TAB DATA/Connections/Workbook Connections/Add... then just add...

Cross posted at: http://www.ozgrid.com/forum/showthread.php?t=160757 Hi, I have a somewhat simple function put together that has one purpose. It takes the arguments as provided inserts them as strings into an SQL statement, then executes that SQL on a recordset connection to an Access DB...