http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpFolderFiles - Import Data from All EXCEL Files in a single Folder via TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpFldWrkFiles - Import Data from Specific Worksheets in All EXCEL Files in a single Folder via TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpAllWkshts - Import Data from All Worksheets in a single EXCEL File into One Table via TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpAllWktsSepTbl - Import Data from All Worksheets in a single EXCEL File into Separate Tables via TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpWktFilesSepTbls - Import Data from A Specific Worksheet in All EXCEL Files in a single Folder into Separate Tables via TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpBrowseFile - Browse to a single EXCEL File and Import Data from that EXCEL File via TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpBrsFldFiles - Browse to a single Folder and Import Data from All EXCEL Files in that Folder via TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpSQL - Read Data from EXCEL File via Query (SQL Statement)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#WriteFileRst - Write Data From an EXCEL Worksheet into a Recordset using Automation (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#DataTypeErr - Avoid DataType Mismatch Errors when Importing Data from an EXCEL File or when Linking to an EXCEL File
------------- Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/ - http://www.accessmvp.com/KDSnell/
|