Rick,
Many many thanks. You have solved the problem. The 2 batch files look
like this.
the calling batch file
@echo off
cls
d:
cd\temp
if exist items.txt del items.txt
FOR %%p in (*.txt) do call c:\process %%p
process.bat
move /y %1 items.txt
mysqlimport -v --local -u -p --lines-terminated-by="\r\n"
--fields-terminated-by="\t" --columns=name,quantity timesheet
items.txt
del items.txt
The last delete statement is to prevent items.txt from being loaded
twice.
Pranav
---------------------------------------------------------------------------------------------------------------------------------------
Pranav
--
----------------------------------------
WIN-HOME Archives: http://PEACH.EASE.LSOFT.COM/archives/WIN-HOME.html
Contact the List Owner about anything: [EMAIL PROTECTED]
Official Win-Home List Members Profiles Page
http://www.besteffort.com/winhome/Profiles.html