Help with Recordsets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with an ID field and a text field. I want to create a new
table from this that maintains the ID field and pulls out a specific string
from the text field. I've set up a recordset and can loop through the
recordset and I can manipulate the text field to get the string I need.
Trouble is I only know how to use rst.edit and rst.update to change the
records in the current table. I can't create a new table with the new data.

Can anyone point me in the right direction, many thanks.
 
Try a make table query, which wouldn't involve a recordset at all:

SELECT OrigTable.IDField, OrigTable.Field2
INTO NewTable
FROM OrigTable;

In place of OrigTable.Field2, put the expression that you use to extract the
desired text value from the field.
 
Back
Top