I have an existing table in an Access DB that I want my user to be able to copy by pressing a button. When the user presses the button, they should be prompted for what is to be the name of the table. The program should then copy the existing table into the Access DB with the new name, and add the new table's name to a combobox showing the list of tables in the DB including the new one. Of course, this new table will need to show up in my dataset as well so I can use the data the user will plug into the new table.
Can anyone get me started on how to copy the Access table and have it show up in my dataset?