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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Import Data from Excel to SQL Server using Ado
Hi All! Have anyone ever import data from Excel to SQL Server using ado? Here is the code that gives me an error: [OLE/DB Provider returned message: Unspecified error] Dim lngRecsAff As Long Dim strSQL As StringSet Conn = New ADODB.Connection Conn.Open DbConnection() strSQL = "Select...- Dima09
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to to bind recordset to subform using ADO
I am trying to bind recordset to subform using ADO and it shows only one record. Do you know what is missing here? Thank you. Private Sub Form_Load() Dim rs As ADODB.Recordset Dim strSQL As String Set conn = New ADODB.Connection conn.Open DbConnection Set rs = New ADODB.RecordsetstrSQL =...- Dima09
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
