MOVE records from c\ to c:\

[sal21]

Have 2 database in C:\ STAT_2016 and STAT_2017.
wth a vb6 code possible to select * from STAT_2016 WHERE anno='2017' and cut and append up STAT_2017?

note:
all database have the same table name

[HansV]

Open an ADODB connection to the database in STAT_2016. First, execute the following SQL to append the records to the target table:

Code: Select all

    strSQL = "INSERT INTO TableName IN C:\STAT_2017\Database.mdb SELECT TableName.* FROM TableName"

Then execute the following SQL to delete the records from the source table:

Code: Select all

    strSQL = "DELETE TableName.* FROM TableName"

Substitute the correct names and paths.