How do I do this in VB
I'm not sure if this makes sense:
Here is my subroutine that does not currently work:
Public Sub DB_CopyTable(ByVal DBPathName$, ByVal TargetTable$, ByVal NewTableName$)
cnxModelDB.Execute "SELECT " & TargetTable & ".* INTO " & TargetTable & " IN '" & DBPathName & "' From " & NewTableName
BPathName - path to Target Database
TargetTable - Table Name from the Source Database BUT if this is the case, I'm not sure where I'd indicate the location of this source database...do I need to do something beforehand or put in the whole path???
NewTableName - New Name when copied to Target Database
I'm not sure if I should have the connection of the target DB or the source DB...I don't think it really matters though (?)
Please help! I just need to know the connections, and syntax needed to perform this operation before I create a recordset to query the target DB with all the tables included in it.