how to Insert data into external db

[tony007]

Hi experts. I want to learn how i can insert data in to external db using vba.
For example , i want insert table names in to the external db.
(A command button in a form )I be happy if some one show me how. Thanks

[RobDog888]

Its allot of steps but you need to connect to your db using ADO, for example, and then execute an Insert
statement to create a new table.

Check out this thread for a tutorial and discussion on using dbs and ado.