*<snip>

>2. sql is not really necessary, you can use the Database clause of the Copy statement to automatically choose (but not create, unfortuneately) the temp database
>3. with scatter to array, you don't care about any of this. First field gets scattered into the first element of the array, nth into nth, so as long as you don't forget the Memo keyword and the structures match sufficiently (i.e. you don't get "data type mismatch"), you don't need to know anything about the names.

Thank you Dragan, that's a keeper.