Skip to content

Tag: adodb

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