Hey Guys,

I have data in tableA that needs to be in tableB in the same DB.

I was wondering if I could use FOR EACH to move the data from table to table.

I've never used the statement before and have not found the info I need. Can someone help me with this?

Thanks,
Krs

You would be best off to do this procedure with the database. Doing it thru ASP is kind of silly. Depending on what data you need to move, the criteria, the field structure, etc, you should be able to do this with a fairly simple database query. Something like this query should get you started:

INSERT INTO TableB(Field1, Field2, Field3) SELECT FieldX, FieldY, FieldZ FROM TableA

All you need to do is send this query to the database from a single ASP db connection and let the database do all the work.

Peter
-------------------------
Work smarter, not harder