Current recordset does not support updating in vb6 Free chatting with hot girls without signin or login
Hi, Why are u "Late Binding" the Object by creating...? EDIT: str Archive Path is previously set directly in code, and does end with a "\".
Write "Excel connection opened" ' Load ADO Recordset with Excel Data Set rst Excel = Server. Write "Excel Recordset loaded" ' Open Access Connection Set cnn Access = Server. The current record remains current after you call the method. Recordset Dim str Old First As String Dim str Old Last As String Dim str Message As String ` Open recordset with names from Employee table. str Cnn = "driver=;server=srv;" & _ "uid=sa;pwd=;database=pubs" Set rst Employees = New ADODB. I have a ASP page where a user will upload a excel file. After the file is successfully uploaded I want to take the rows in the REGION tab and insert them into an MS Access 2007 table.
This may be a limitation of the Provider, or of the select Locktype).