If all you want to do is to copy a table from one database to another, take a look at this post of mine.
http://forums.vb-world.net/showthrea...threadid=17011
It's DAO, but I'm sure you can convert it.