Importing Data from txt file to DB

[minckle]

Im writing an application using Delphi 5 and MySQL backend. The application deals with customer contact details. I want a function so the customer can import a file of contacts into the DB.
Seperately,I can use the MySQLImport function via command prompt and it imports the file OK, below

C:\mysql\bin\mysqlimport -u UserName -pPassword --local --columns client_id,forename,surname,mob_number --fields-terminated-by=, --lines-terminated-by=\r\n itextit c:\contact.txt

but, how do i go about running it via delphi, is there a way to run the above from the command prompt using delphi?????

Hope you understand what im trying to do

Any Help or advice appreciated

 

[hilfy]

Look at the WinExec function. We've used it something like this:

  CmdFile := '"' + UpdateSourceDir + 'AutoUpdate.exe"';
  CmdParm := '/U="' + DirToUpdate + '" ' +
    '/S="' + UpdateSourceDir + '" ' +
    '/P="' + ApplicationToStartWhenFinished + '" ' +
    '/A="' + UpdateFile + '"';
  RetVal := WinExec(PChar(CmdFile + ' ' + CmdParm), SW_SHOW);
  Result := RetVal > 32;
  if not Result then
  begin
    ShellApiError(RetVal);
  end;

-Dell