Dear Expert,
I'm getting error 2391 field 'f1' doesn't exist in destination table
Help me!!!!!!!!!!!!!!!!
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