Current recordset does not support updating vbscript
For this example we'll assume that we'll need to have our first Recordset populated with records that from the table.
Here is an example: The user would be able to change existing records, even possibly to delete an existing record but not create a new record.But before we start examining Multiple Recordsets, let's look at a common task in ASP and how it is handled without using Multiple Recordsets.When developing ASP pages, there are times when our ASP programming logic requires us to retrieve multiple recordsets that originate from multiple tables that have no direct relationship between them.Data in an Excel workbook can come from two different locations.
The data may be stored directly in the workbook, or it may be stored in an external data source, such as a text file, a database, or an Online Analytical Processing (OLAP) cube.
However, you can immediately display the most current data by refreshing the records.