The batch will import the filename within the file man into the table corresponding name _dos/bat

Use batch implementation to import the photo name in the photo file into the 1 table corresponding to the name

Method One

/*&cls
@echo off
dir/b "photo \*.jpg" |cscript-nologo-e:jscript "%~f0"
Pause & exit/b
* *

var Jpglist = ';
while (! WScript.StdIn.AtEndOfStream) {
  jpglist + = WScript.StdIn.ReadLine () + ' \ R ';
}
var fd = new ActiveXObject ("Scripting.FileSystemObject"). GetFolder ("."). Path
var objexcel = new ActiveXObject ("Excel.Application");
var objbook = ObjExcel.Workbooks.open (fd+ ' \\1.xls ');
objBook.Worksheets (1). Activate;
var objsheet = Objbook.activesheet;
var cnt = ObjSheet.usedrange.rows.count;
for (var i = 1; i<=cnt; i++) {
  var A1 = Objsheet.cells (i, 1). value;
  var re = new RegExp ("[^\\r]*?") +a1+ "[^\\r]*?\\.jpg", "IG");
  var m = Jpglist.match (re);
  if (m) Objsheet.cells (I, 2). value = M[0];
}
Objbook.saveas (fd+ ' \\2.xls ');
Objbook.close ();
Objexcel.quit ();

Method Two (more simplified):

@echo off
>$ dir/b "Photo \*.jpg"
(for/f "Tokens=1 delims=,"%%a in (1.csv) do (
  set/p "=%%a", "
  findstr" %%a "$| | echo;
)) <nul>2.csv
del $
Pause