title: Importing data from excel and inserting into normalized sql tables
body: <p>I have an excel file with 815 records that includes service name and charge.
  In the database, some records have been entered so remaining 781 records need to inserted.</p>
  
  <p>The problem is that there are 2 tables, one is departmentalservices and the other is deptservicedetails.
  Departmental service table has service name (among other things) and is joined to deptservicedetails by a column called service_id. Deptservicedetails is where the charge for that service will be present (as there are cash and credit charges but dont worry about that). Departmental services has all the service names but the charges for each of them is not present in the details table.</p>
  
  <p>Now if I use the program normally to insert the charges, its gonna take long as you know.
  Hence, is there a way in which i can write multiple insert queries (using excel formula) or something that would match a name in the excel sheet with an id in the table and hence I can insert a record into the details table by id.</p>
  
  <p>At the moment I could write an insert query with name and charge but the details table requires service id and not name with an insert query.</p>
  
  <p>Hope its understood and thanks.</p>