I am pulling data out of one table, validating the invididual fields for
numeric or date values, and inserting all of the data in a new table. I'm
trying to find an efficient method for accomplishing this.

Here are my current thoughts:

open recordsource
loop records (
validate record field one, store in array
validate record field two, store in array
)

Now I have an array of 12000 records and I want to insert them all into a new
table. Looping the array and inserting each record is not practical.

Any thoughts on a better way to accomplish this? (I don't want to alter the
first table in any way)

Is it possible to run an insert into statement that selects all fields from
an array?

Thanks!

--
Message posted via http://www.accessmonster.com

Why not just create a single SQL Insert Query that will use criteria
to filter out the "bad" data?

On Feb 21, 5:49 pm, "andy_42 via AccessMonster.com" <u28081@uwe>
wrote:
> I am pulling data out of one table, validating the invididual fields for
> numeric or date values, and inserting all of the data in a new table. I'm
> trying to find an efficient method for accomplishing this.
>
> Here are my current thoughts:
>
> open recordsource
> loop records (
> validate record field one, store in array
> validate record field two, store in array
> )
>
> Now I have an array of 12000 records and I want to insert them all into a new
> table. Looping the array and inserting each record is not practical.
>
> Any thoughts on a better way to accomplish this? (I don't want to alter the
> first table in any way)
>
> Is it possible to run an insert into statement that selects all fields from
> an array?
>
> Thanks!
>
> --
> Message posted viahttp://www.accessmonster.com

Hi Andy,

Couldn't you just run an Insert Into from your original table? You could
perform some validation as you proceed if you are simply checking for a
numeric/date value etc.

Damian.

"andy_42 via AccessMonster.com" wrote:

> I am pulling data out of one table, validating the invididual fields for
> numeric or date values, and inserting all of the data in a new table. I'm
> trying to find an efficient method for accomplishing this.
>
> Here are my current thoughts:
>
> open recordsource
> loop records (
> validate record field one, store in array
> validate record field two, store in array
> )
>
> Now I have an array of 12000 records and I want to insert them all into a new
> table. Looping the array and inserting each record is not practical.
>
> Any thoughts on a better way to accomplish this? (I don't want to alter the
> first table in any way)
>
> Is it possible to run an insert into statement that selects all fields from
> an array?
>
> Thanks!
>
> --
> Message posted via http://www.accessmonster.com
>
>