I need to retrieve some rows from an excel sheet and put the information in two diferent tables.
In my excel sheet I have 4 columns (client, project, begining, end), so the first two columns will go to table project(id_project, fk_client,project_name...) and the other two (begin,end) to project_duration (id_project, begin, end).
My idea was to create a view in the database to get the max ID from project to insert into the duration table.I runned the job and all data was passed to both table, but id_project didn't go to project_duration.
Can anyone help me with a better solution? Thanks!
Solved! Go to Solution.
@isadoralmeida06, did it help you?
In this case thank's to mark this case as resolved (Kudos also accepted).
That's what I was doing it, like I said on the post, that's the ideia I had as shown on the PNG I attached, but it was still putting the wrong ids. Anyways, I got it fixed.