S
Sash
I have a form where the user will key in a number associated with a directory
structure for many CDs that contain a database that I need to import the
data. I was going to have a TEMP table so that eventually this form will
drop all records in TEMP, transfer the data and then run an append query to
the main table. However, I keep getting the above error when I try to run
this code. Any ideas?
Dim stDBName, stSource, stDestination As String
stDBName = "E:\" & Me!ProjNum & "\PROJECT\DATA.mdb"
stSource = "DB1"
stDestination = "TEMP"
DoCmd.TransferDatabase , , stDBName, acTable, stSource, stDestination, False
structure for many CDs that contain a database that I need to import the
data. I was going to have a TEMP table so that eventually this form will
drop all records in TEMP, transfer the data and then run an append query to
the main table. However, I keep getting the above error when I try to run
this code. Any ideas?
Dim stDBName, stSource, stDestination As String
stDBName = "E:\" & Me!ProjNum & "\PROJECT\DATA.mdb"
stSource = "DB1"
stDestination = "TEMP"
DoCmd.TransferDatabase , , stDBName, acTable, stSource, stDestination, False