Copy a database table
How to copy a database table. This may require some tweaking….“Bill Pearson” Original Author: Newsgroup Posting Code Private Sub Form_Load() Dim dbFrom As Database Dim dbTo As Database Set dbFrom = workspaces(0).opendatabase(“c:vb4iblio.mdb”) Set dbTo = workspaces(0).opendatabase(“c:vb4iblio.mdb”) db_Copy_Tabledef dbFrom, dbTo, “Authors”, “CopyOfAuthors” dbFrom.Close dbTo.Close End SubPublic Function db_Copy_Tabledef(dbFrom As Database, dbTo As Database,TableNameFrom As String, TableNameTo As String) As Boolean Dim tdFrom As TableDef Dim tdTo As TableDef Dim fldFrom As Field Dim fldTo As… Read More »