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

    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
    Code:
    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.Clear
            .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!"
            Else
                MsgBox "Operation Cancelled"
            End If
        End With
    Help me!!!!!!!!!!!!!!!!

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    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 foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    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
  •