Merge/Copy Tables to Access

[llam]

I have more than a hundred database on pervasive.
I want to merge one of the tables in all database into one table in access. Instead of using ODBC link, I would like to do it as DSN-less using PervasiveOLEDB in VBA.
I tried copy the records one by one in each tables in each database, but it is slow.
How should I do it? The major goal that I would like to archieve is to put all tables from different database into one table in access.
Thanks!

-- llam

 

[kupe]

I'd like to know too. I have three tables that I would like to have as one table. I can't find any sql, or any Access method either, to do it, other than Ilam's way - which is long and tedious.
Cheers from a Hopeful in gloomy UK
Kupe

 

[kupe]

Found the answer on tek-tips page,
thread700-449362 thanks to WildHareJim.