Coming at this from another angle, you say that this was originally built in access and is now being moved to a more robust (or at least new) platform? Is that correct?

Can you not just use the new platform, open a connection to the access database, open a connection to your new database, and do a series of CREATE TABLE and SELECT INTO statements?

If not, bummer. And I wasn't trying to blame you for using access or anything, I know how the little projects go and how little they pay attention to programmers.

Sounds like mparker knows views & access a little better than I, best of luck solving your quandary