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

Reply via email to