Automatically link tables

DoCmd.TransferSpreadsheet transfertype:=acLink, _
            spreadsheettype:=acSpreadsheetTypeExcel5, _
            tablename:="AARWeek2", _
            Filename:="F:\DB\AAR\AAR.week2.xls", _
            hasfieldnames:=True, _
            Range:="Sheet1!"

Private Sub cmdImportTextFile_Click()

'Requires reference to Microsoft Office 10.0 Object Library.

   Dim fDialog As Office.FileDialog
   Dim varFile As Variant

   'Clear listbox contents.
   Me.FileList.RowSource = ""

   'Set up the File Dialog.
   Set fDialog = Application.FileDialog(msoFileDialogFilePicker)
   With fDialog
      'Allow user to make multiple selections in dialog box
      .AllowMultiSelect = True
            
      'Set the title of the dialog box.
      .Title = "Please select one or more files"

      'Clear out the current filters, and add our own.
      .Filters.Clear
      .Filters.Add "Text Files", "*.TXT,*.CSV"
      .Filters.Add "All Files", "*.*"

      'Show the dialog box. If the .Show method returns True, the
      'user picked at least one file. If the .Show method returns
      'False, the user clicked Cancel.
      If .Show = True Then
         'Loop through each file selected and add it to our list box.
         For Each varFile In .SelectedItems
            DoCmd.TransferText acImportDelim, "your file import spec", "tblImport", varFile, True
         Next
      Else
         MsgBox "You clicked Cancel in the file dialog box."
      End If
   End With

   'assuming you have an update query for writing the dates:
   'comment out the code below if you have not. 
   'change the name of the update query to suit
   Set dbs = CurrentDb()
   Set qdf = dbs.QueryDefs("qupWriteDates")
   DoCmd.RunSQL qdf.SQL
   Set qdf = Nothing
   Set dbs = Nothing
   Set fDialog = Nothing

End Sub