basically what i have is an access.mdb with say, 50 tables in it. i need to create another database with say 23 of the tables from the original database.

so far, i have created a page that first renames the current database with the current date to be kept as a backup. then i have a new empty .mdb file created.

now i have my source .mdb, a copy of my previous destination .mdb, and a brand new blank .mdb with the proper name waiting for tables from the source .mdb.

any suggestions on how to get only the tables i need from the source .mdb into the new blank .mdb???

any help would be greatly appreciated. thanks in advance.

You're getting a little (ok, a lot) out of my area of expertise on just how you do this, but I'll throw something out for you. I know you can export and import an Access database to Excel. Why not export your database to Excel, get rid of the stuff you don't need from it there, then import it into your new database? Seems to me like that would work. What do you think?

Pat Wong
http://www.napathon.net/ - Music Around The World
For collecting tips, trade and want lists, album reviews and more.

Hi Jim,

Can you simply:

1. File > Get External Data > Import
2. Select your source .mdb
3. Select the tables you want from the Import Objects dialog

Bob