I have a unbound text box that holds the full path of a file I want to include in my transfertext - I've tried the following code, but it still tells me that I need a filename?
Dim strLongFileName As String
Me.TxtProfile.Value = strLongFileName
DoCmd.TransferText acImportDelim, , "tblImport", strLongFileName, False
What have i missed out?
Thanks in advance