I am trying to connect to SQL Server from Excel VBA using the following code and with some specific simple queries it actually works like a charm. My problem shows up whenever I try to run the query right below to which I get the following error: ‘-2147217900 (80040e14)’ An expression of non-boolean type specified in a context where a
Tag: adodb
Excel SQL VBA: adding more than one cmd parameter
I am writing SQL-query, and I get error with string value: I tried to add more than one cmd parameter to solve this problem: But I also get an error. How do I set more than one cmd parameter and use it in my query? Table I am working with: here. Answer The parameter to CreateParameter are The Direction –
Writing Query statement with a String and a Date in Excel VBA
Using an ADODB connection, I have an excel database where I store data, and I am trying to make a query in one of the sheets(db_Reports). Values for Lastname and Birthday are entered in textboxes (tb_Lastname & tb_bday, respectively) from a userform. My problem is that the first two query statements work (commented in this case): one queries Lastname which
ADODB Connection to two access database
Due to ms access 2GB limitations on space; i am considering splitting a database into two. However I regularly rely on SQL statements such as the following: Is there a way in ADODB to perform the above, ie INSERT INTO table in file 1, the SELECT data from a table in file 2 ? Answer Here’s an example of updating