You need to first generate a list of all the tables; this can be done manually via a simple .xls list for example or automatically via a query of the Access DB's 'sysObjects' table.
Once you have the list you can then set a loop within you're load script (For i to n...) to load through the tables.
Take a look at the script of my SQL Extractor qvw as that should point you in the right direction - the password for the Hidden Script is '1234'.
Hope that helps,
Matt - Visual Analytics Ltd
I am trying to adopt your script to help me get all the tables from my MSAccess db.
What I did is to change sys.objects to MSysObjects (else I get error that there is no sys.mdb file).
I use this string for connecting the db:
And I got the error: no read permitions to MSysObjectstable.
My dbase is MSAccess 2000.