



You then Loop through each record, using the contents of the filePath field to direct subsequent, standard, file imports.Ī script off the top of my head for this would be: You'd create a new table, "ImportToDo" for example, to hold those file paths.Īfter you do this "Import Folder" step, you will have a table with one record per file. You do not want to import the field contents or file name, just the full file path. When you use the import folder command, there are actually three items available for mapping to fields: the content of the file the file name and the full path to the file. Then once you have this list you can use a script to step through each item and perform the individual import of the data in that file. command to obtain the list of 80 files that must be imported. Yes, there is a way to acocmplish what you want.Īssuming that you are importing text files (literally, files ending in.
