• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Function to Copy Tables from an Access Database to another Database. Another programming ease for A

Function to Copy Tables from an Access Database to another Database. Another programming ease for A

Function to Copy Tables from an Access Database to another Database. Another programming ease for ADO Programmers. Just Three(3) Arguments to

API Declarations


'You only need to supply the following:
'DBPathName - supply the correct path and name of the Target Database
'<app.path "\james.mdb">
'TargetTable - supply the TableName from the Source Database
'NewTableName - supply the New Table Name when copied to the Target Database
'Feel free to use my code with ease.



Rate Function to Copy Tables from an Access Database to another Database. Another programming ease for A

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

On Error GoTo ErrorHandler:
    Connection.Execute "SELECT " & TargetTable & ".* INTO " & TargetTable & " IN '" & DBPathName & "' From " & NewTableName
    Exit Sub
ErrorHandler:
    MsgBox "Error: " & Err.Description, vbCritical + vbOKOnly, "Error " & Err.Number & " in CopyTable!"
End Sub