Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2012

    Unanswered: Error 2391 Field 'f1' Doesn't Exist In Destination Table, Access 2013

    Dear Expert,
    I'm getting error 2391 field 'f1' doesn't exist in destination table
    Dim FileBrowse As Office.FileDialog
        Dim varFile As Variant
        Dim sFile As String
        Set FileBrowse = Application.FileDialog(msoFileDialogFilePicker)
        With FileBrowse
            .AllowMultiSelect = False ' <= Set to true if you need to select more than one text file
            .Title = "Please Select the File For Import"
            .Filters.Add "Text Files", "*.txt"
            .Filters.Add "All Files", "*.*"
            If .Show = True Then
                sFile = .SelectedItems(1)
                DoCmd.TransferText acImportDelim, , Me.cboTableList, sFile, False
                MsgBox "Transfer Complete!"
                MsgBox "Operation Cancelled"
            End If
        End With
    Help me!!!!!!!!!!!!!!!!

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    This problem has apparently been around since v2000 and has never been addressed by the Boys of Redmond! Here's an article on the subject; its title says Access 2000, but the same should apply to all subsequent versions:

    ACC2000: "Field 'F1' Doesn't Exist in Destination Table" Error Message

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Mar 2009
    Provided Answers: 15
    Quote Originally Posted by abzalali View Post
    Help me!!!!!!!!!!!!!!!!
    courtesy requires that you at least give feedback when you receive answers to a question you posted : is the proposed solution satisfactory, if not why, etc.

    Failing in doing so does not motivates to keep on trying to help you.
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts