I've got a couple years of VB experience and am always looking for the best
way to do things. What is the best way to copy the entire contents of a table
on our AS/400 (ODBC datasource) to an MS-Access database. I kow I can set
up SQL statements to loop through the source record set and use the Addnew
after building a long string but I wonder if there is a simpler way. both
tables and all fields are the same name and type, it's a straight clone task
of about 30 tables.
Using VB6

Thanks,

Vince