You will have to have a vb program that will connect to access via DAO/ADO. The run the query to pull into a recordset in vb then you can export to Excel. MSDN has code on how to export to excel at that point. Or I can post it...
You can change the the cursor location to conn.CursorLocation = adUseServer 'access perfers you to user server cursor vs client...Sql is the opposite
also the default cachesize is 1 depending on the number of records that you pull on the average bump it up to something more reasonable and it...
I am looking for some code that will get the clsid from a .dll or .ocx. I know I can register it and get it from the registry but I want to get the clsid from the file not the registry. This is so I can check and see if the file is then registered.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.