Help pls change ADODB.Recordset and adodb.connection with New.ADODB.Recordset and New.adodb.connection
in that code:
Please Login or Register to view this content.
Help pls change ADODB.Recordset and adodb.connection with New.ADODB.Recordset and New.adodb.connection
in that code:
Please Login or Register to view this content.
Maybe this article can help you with the task. It uses an Excel table and the SUBSTITUTE command to rewrite the command string (record set). Something similar might be able to be done for the connection. http://www.utteraccess.com/wiki/index.php/MS_Query
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks