Creating a paradox table using ADO

I want to create a paradox table at run time, using an TABOQuery. The Table is copied from an MSAccess table.

I get the error "Syntax error in query: Incomplete query clause" from this SQL

ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('SELECT Mileage.UnitID, Mileage.Date, Mileage.Time,');
    ADOQuery1.SQL.Add('       Mileage.CalcMile, Mileage.Mileage');
    ADOQuery1.SQL.Add('INTO '''+ExtractFileName(sTargetPath)+'''');
    ADOQuery1.SQL.Add('IN '''+ExtractFilePath(sTargetPath)+'''');
    ADOQuery1.SQL.Add('FROM Mileage;');
    ADOQuery1.Open;


Thanks in advance,
                      Rick.