Once youve verified that all the files you want are listed, click the Combine Binaries button from the Content column. By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. Generally, you will choose the option "delimited." Using MS Access to import multiple text files, http://www.datawright.com.au/access_resources/access_import_text_files.htm, http://www.access-programmers.co.uk/forums/showthread.php?t=213261, How Intuit democratizes AI development across teams through reusability. Sometimes, this is simple because the Excel spreadsheet is just one sheet. For more information, see Import data from external data sources (Power Query). Follow the steps: 1. I think you can just set the error handling as follows: Then, if you get a failure on any one line, VBA will just jump to the next line. Go to File | Get External Data | Link Tables. A list of the files in the folder appears in the