My supervisor at work was interested in archiving trades stored in Excel worksheets in one giant Excel database. I suggested using an Access database instead. What follows was based primarily on a response from from HansUp on StackOverflow.com to a user with a question similar to mine (http://goo.gl/D#EUk). This stub imports the data stored in t…

vbaImportExcelWkstData

Public Sub ImportExcelWorksheetData()

    Dim strPath As String
    
    strPath = "C:\Documents and Settings\Some Folder\temp.xls"
  
    DoCmd.TransferSpreadsheet acImport, , "tblTemp", _
        strPath, True
        
End Sub