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
Printable View
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
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.