On a server side script I want to extract a subset of records to a new
database.
The new database should have the same structure as the original but should
only
contain records that match my criteria.

TIA.

There are specific methods for each database format for creation of the database unit, tables and records (including
indexes).

Access and DBF are easy - there are 3rd party components and scripts that will do the job a lot faster and better than
you could.

http://asp-database-recordset-converter-dbf-mdb-export.pstruh.cz/help...

I've got this one and it's excellent to be honest - very fast.

SQL Server and Oracle etc. (all true RDBMS systems) are a bit more difficult in that there is a lot more security and
consistency stuff going on at the database systems level to deal with. However, both at least provide documented
function and methods to create databases, tables and records - DTS, T-SQL (never used Oracle so I can't really comment).

Hope this helps.

Chris.

On a server side script I want to extract a subset of records to a new
database.
The new database should have the same structure as the original but should
only
contain records that match my criteria.

TIA.

You can do queries into the database, add the recordsets to the conversion object and when you have the collection that
you want it'll rite the Access DB file directly to disk.

Chris Barber.

Hi DrBob

I think you mean table by database. If that's the case why not use standard
sql which create a table based on the query. e.g.

conn.execute "select * into new_table_name from old_table where
some_condition"

--
Have a nice day.
Han Pohwan, Microsoft MVP, Korea