If you've been searching for a way to use the table structure in an existing Microsoft Access database in another table, then check out this quick tip. It shows how to copy and customize the table ...

I'm fairly certain what you want to be using is DTS. It the wizard interface lives under Import/Export data. IMO, It's one of the best tools that has ever been designed for the computer.