|
Using an UPDATE query in SQL.REQUEST to
change values in closed workbooks.
|
|
How to COUNT data in an Excel table and in an MsAccess database using
SQL.REQUEST.
|
| Download these two files and extract them into the same
folder:
|
No VBA used.
|
| If you do not have Access on your machine, the Access
example probably
won't work. If you do have Access, make sure you
change the path to the Northwind database on your PC. |
| |
| |
| See the notes in sqlrequest.html
concerning the XLODBC.add-in |
| |
