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 Chris Miller 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
I have a run time error for creating duplicate values. How do I have the ADO reveiw each record and if the ID already exists, continue or skip to add the others? Here is the code: DoCmd.TransferSpreadsheet acLink, 8, "lnkImport", varFileName, True, "Sheet1!a1:g1000" Set Conn = New...- Dima09
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
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
What do you mean "Only certain bound rs are editable"? Can you be more specific?- Dima09
- Post #5
- Forum: Microsoft: Access Forms
-
How to to bind recordset to subform using ADO
I did figure out, but now I cannot edit. Here is the code: Dim rs As ADODB.Recordset Dim strSQL As String Set conn = New ADODB.Connection conn.Open DbConnection Set rs = New ADODB.Recordset strSQL = "SELECT * FROM TreatmentProvided WHERE " & strCriteria & "" rs.CursorLocation = adUseClient...- Dima09
- Post #3
- Forum: Microsoft: Access Forms
-
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
