Hey there,
Is there a way to run DoCmd.TransferText and run a different Import Spec based on a user selection from an option group on a form? I can set it up to run a specific spec but do not see an argument for a "Where" option.
Private Sub Command17_Click()
Dim strfileName As String
strSpec = "Import-RDS"
strfileName = "\\Path\UnshipRDS.txt"
DoCmd.TransferText , strSpec, "Unship RDS", strfileName, Yes
End Sub
Ideally, I would love to have just one Import Spec with a variable using the same option group/form but from my searches don't see how that is possible using the automated Import spec process in Access.
Thanks!