Its me agian. Lets see how bad I can screw this simple one up.

You can copy database objects with this...
VB Code:
  1. Application.DoCmd.CopyObject "DestinationDatabase", "NewName", acTable, "Table1"
How do you mean format the columns? In Table view in Access?