To read the table names from Access is simple: issue an SQL command:
SELECT Name FROM MSysObjects WHERE (Name Not Like "MSys*") AND (Type In (1,4,6)) ORDER BY Name
and it will return them.
But ... Access doesn't support table renaming via the ALTER TABLE SQL command, so you would have to create a new table with the new name and the same structure as the old, copy all the rows over and then delete the original.Since this sounds very much like a "one of" job, I'd do it manually in Access - it'll be a load easier, and probably both more reliable and quicker!