External Database

  • Thread starter Thread starter David W
  • Start date Start date
D

David W

how would you go about copying data to an existing database outside of the
current

example
current database "myprimary"

external database name "mydata"
tbl mylogs
fields log1,log2

I am wanting to copy to the external database without showing it
 
This example should help:

strTable = "mylogs"
strFile = "C:\MyPath\mydata.mdb"
strSQL = "SELECT * INTO [" & strTable & "] IN """ & strFile & """ FROM
[" & strTable & "];"
dbEngine(0)(0).Execute strSQL, dbFailOnError
 
Back
Top