Hi, for some reason I am getting a "2498" error “An expression you entered is the wrong data type for one of the arguments” when I attempt to run this DoCmd.TransferDatabase feature.
What am I doing wrong? I have triple check ALL the names.
E:\NCHE\ExternalDatatoImport\comprehensivedatafiles.mdb is the location I am copying from
The code resides and the table is being copied to E:\NCHE\WorkingFiles\Issues5.mdb
The table name I want copied is data_members
The table I am importing to is also called data_members and is just structure.
Here’s my code:
Private Sub cmdImport_Click()
Dim strNAME As String
strNAME = Me.txtProperties
Dim intAwnser As Integer
intAwnser = MsgBox("Are you sure you want to run the import function?", 4 + vbCritical, "Run Import?")
If intAwnser = 6 Then
DoCmd.TransferDatabase acImport, , "E:\NCHE\ExternalDatatoImport\comprehensivedatafiles.mdb", acTable, "data_members", "data_members", "False"
If any one can see what I am doing wrong I would really appreciate it!