Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using VB to Export an Access Query to Excel
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...- gonzoaz
- Post #2
- Forum: Visual Basic (Classic)
-
ADO/DAO speed w/Mdb - dissapointed!
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...- gonzoaz
- Post #7
- Forum: Visual Basic (Classic)
-
Clsid/guid from .dll or .ocx not registered
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.- gonzoaz
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
