I'm not sure if I understood either.
Maybe you just need a script like this:
month(Bookdate) as Bookmonth,
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
With the *, you can read all the files with similar names in the folder and create a field for all of them.
Hope this helps,