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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: SabreWolf3
- Order by date
-
retrieving data from ODBC source into Excel
Sorry, I am new to this forum. I clicked submit by accident, and before I knew it... my post had gone up without me asking my question. The above code has 2 problems: • First, there should have been over 10,000 results returned from the query. When I run the query, it only takes about 2...- SabreWolf3
- Post #2
- Forum: -General database discussion
-
retrieving data from ODBC source into Excel
Sub dbconnect3() Dim wkrJet As DAO.Workspace, wrkODBC As DAO.Workspace Dim conODBCDirect As DAO.Connection Dim rsODBCDirect As DAO.Recordset Dim strConn As String strConn = "ODBC;DATABASE=dbname;UID=username;PWD=password;DSN=dbname;LOGINTIMEOUT=50;" Set wrkODBC =...- SabreWolf3
- Thread
- Replies: 3
- Forum: -General database discussion
