Seth Galitzer
sgsax at ksu.edu
Fri Apr 25 10:40:21 CDT 2003
Ryan, Off the top of my head, that's it. You can make things easier on yourself if you name the internal tables' fields the same as the external fields. Then you can iterate through the fields using their index number instead of their names. But this is not always desirable. Is this going to be a one time dump, or will you need to do this frequently? If just one time, then I'd seriously look at just making an ODBC link so you can make a set of append queries. Seth On Fri, 2003-04-25 at 10:18, Smethurst, Ryan wrote: > > Seth, > > Having looked at the solution below and the situation I'm in... > > I have about 15 tables which need to be updated in this way, some of which > have dozens of fields. Is there a quicker way to batch insert from a > recordset into a table, or must it be done field by field and record by > record as you have below? > > Ryan > -- Seth Galitzer sgsax at ksu.edu Computing Specialist http://puma.agron.ksu.edu/~sgsax Dept. of Plant Pathology Kansas State University