Re: From oracle to MS access through VB5

INSERT AccessTable

    SELECT [Columns]
    FROM OracleTable
    WHERE [Yada yada yada]

If that doesn't fit the bill, I can probably suggest more options.

Also, if that solution isn't good enough, tell us which technologies you're using. DAO, RDO, ADO, etc.

Steve

PS, A Dynaset is slow looping through. I would suggest you open it as a snapshot with a forward only cursor. An even quicker method is to use GetRows which loads X or all of the records into a Variant Array. However, you're still going to have insert them manually, either using .Add function or an "INSERT" statement.