Insert Statement

[andy_42 via AccessMonster.com]

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!

 

[Jason Lepack]

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

 

[Damian S]

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.